|
|
| Re: libraries how to use it [message #86441 is a reply to message #86436] |
Thu, 30 September 2004 00:57   |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Which Version of Forms you are using.
The use of the EXEC_SQL package from a client tool (eg Forms, Reports, Procedure Builder) with the Open Client Adapter (OCA) for ODBC allows multiple connections to both Oracle and non-Oracle databases to be opened simultaneously.
Developer 6.0.x has the EXEC_SQL package built in. In earlier releases of Developer the functionality was provided by a PL/SQL library (.pll file).
HTH
Regards
Himanshu
|
|
|
|
|
|
| Re: libraries how to use it [message #158361 is a reply to message #86436] |
Fri, 10 February 2006 03:39 |
vban2000
Messages: 207
Registered: March 2005
|
Senior Member |
|
|
Hi
just like Himanshu said, its in the Form/Report/etc..
Open Forms 9i
Open the Object Navigator (Press F3)
enter EXEC_SQL on top-right of the Object Navigator in the Fund field.
It will show you that you have a EXEC_SQL in the BUILD-IN packages..
You can find one example here... (I google it...)
http://asktom.oracle.com/pls/ask/f?p=4950:9:16750885090483291882::NO:9:F4950_P9_DISPLAYID:328617221276
here is a simple example (and comparison)
| Quote: |
Forms: FORMS_DDL ('ALTER USER xyz IDENTIFIED BY xyz');
Reports: SRW.DO_SQL ('ALTER USER xyz IDENTIFIED BY xyz');
ANY PL/SQL:
(Forms,
Graphics,
Reports OR
PROCEDURE
Builder)
DECLARE
v_curs exec_sql.curstype;
v_numrows INTEGER;
BEGIN
v_curs := exec_sql.open_cursor;
exec_sql.parse (v_curs, 'ALTER USER xyz IDENTIFIED BY xyz');
v_numrows := exec_sql.EXECUTE (v_curs);
exec_sql.close_cursor (v_curs);
END;
|
[edit: add example]
regards
AnDy
[Updated on: Fri, 10 February 2006 03:56] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
