Home » SQL & PL/SQL » SQL & PL/SQL » Why can't u use dynamic sql?
Why can't u use dynamic sql? [message #35680] Fri, 05 October 2001 06:00 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: calling function from sp
Next Topic: trigger created with compilation errors
Goto Forum:
  


Current Time: Sat May 25 09:26:26 CDT 2024