Re: [sqr-users] Is there a way to execute an Oracle procedurefrom within an SQR?

["George Jansen" <gjansen@aflcio.org>]

I'm at home, away from SQR & manuals, but it seems to me that you have to 
double the last ';', e.g.

begin-sql
dbms_lock.sleep(60);
end;;
end-sql


>>> thompsob@uww.edu 08/11/05 5:26 PM >>>
Does anyone know of a way to execute an Oracle procedure from within an
SQR? 
 
I had hoped I could an Oracle procedure call in lieu of an SQL statement
just by embedding it between BEGIN-SQL/END-SQL, but that's not working
for me. 
 
The procedure executes okay from Toad's SQL Editor.
 
Thanks,
Betty 
 
++++++++++++++++++++++++++++++++++++++++++
 
Betty Thompson
Applications Development Specialist
University of Wisconsin - Whitewater
800 W. Main Street -- Room L-1015
Whitewater, WI  53190-1790
 
262-472-5532
thompsob@uww.edu
 
++++++++++++++++++++++++++++++++++++++++++

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users