| Regarding DBMS_SQL [message #374134] |
Sun, 27 May 2001 23:58 |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
Hai friends,
I have a doubt regarding DBMS_SQL.
As we know that oracle uses early binding in the PL/SQL.
Hence we are not able to use the DDL Statements in the pl/sql.
To overcome this problem,we are using the DBMS_SQL package.
I know that we have to use the DBMS_SQL package or Native
Dynamic SQL (in oracle 8i). But can anyone explain me
how this DBMS_SQL or Dynamic sql works?
TO make my question clear..
Suppose if i have a create table command in a pl/sql block,
early binding checks for all the objects and privileges and
it finds that my table doesnot exists.Hence this pl/sql
will not run.Until unless this pl/sql is run,my table will
not be created.
But we are able to achieve this thru DBMS_SQL or dynamic
sql.I would like to know how we are able to overcome this
situation.
Thanks in Advance.
Regards,
Giridhar Kodakalla
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
