Home » SQL & PL/SQL » SQL & PL/SQL » Executing An Generated sql statement from a procedure
Executing An Generated sql statement from a procedure [message #35910] Tue, 23 October 2001 08:46 Go to next message
Craig
Messages: 28
Registered: October 2001
Junior Member
I have a stored procedure that generates an SQL Statement. How can I execute that statement within the procedure. EG Execute immediate The_SQL (Execute Immediate is how you do it in DB2)

Many thanks for any help.

----------------------------------------------------------------------

Report message to a moderator

Re: Executing An Generated sql statement from a procedure [message #35913 is a reply to message #35910] Tue, 23 October 2001 09:33 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
execute immediate is available in oracle also. you can use either execute immediate or dbms_sql package.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: wrong number or types of arguments in call to 'PUT_LINE'
Next Topic: Using Return Cursor as out parameter in procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:12:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.