Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing variable from SQL to PL/SQL
>>>>> "M" == M Stratford <mark.stratford_at_misys.com> writes:
M> That's right - when calling a package from SQL*Plus it can't do M> DML. What are you trying to do with the 'SELECT' value..? Can you M> write a PL/SQL wrapper to call your package from..?
do you mean DDL? I call package procedures from within sqlplus all the time and never have any problems and pretty much all of them do DML. Tim
-- Tim Cross The e-mail address on this message is FALSE (obviously!). My real e-mail is to a company in Australia called rapttech and my login is tcross - if you really need to send mail, you should be able to work it out!Received on Wed Jan 15 2003 - 22:40:40 CST