Why can't u use dynamic sql? [message #35680] |
Fri, 05 October 2001 06:00 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
dbms_sql package for version earlier than 8
for higer than version 8, use Native dynamic sql. Besides of these, i dont have any idea. Because changing column name is dynamically changing the SQL.
----------------------------------------------------------------------
|
|
|
TO Frank : Re: Why can't u use dynamic sql? [message #35697 is a reply to message #35680] |
Sun, 07 October 2001 12:34 |
Bj
Messages: 8 Registered: March 1999
|
Junior Member |
|
|
Frank, Thanks for the reply
The reason I was not trying to use dynamic pl/sql
was due to process speed,
If i could have a select statement that could take care of my problem rather than have a dynamic pl/sql, which I 'm not quite sure, but would imagine that it is costlier than a select statement or a stored procedure without dynamic
sql. But it seems dynmaic sql is the only way out
----------------------------------------------------------------------
|
|
|