Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing variable from SQL to PL/SQL

Re: Passing variable from SQL to PL/SQL

From: Tim X <timx_at_spamto.devnul.com>
Date: 16 Jan 2003 15:40:40 +1100
Message-ID: <87n0m17lmf.fsf@tiger.rapttech.com.au>


>>>>> "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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US