Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please Help: Calling Stored Procedures
Why not?
try the command
FORMS_DDL.
command :=
'check_rec.package||'.'||check_rec.proc||'(:range.start_login,:range.end_
login)';
then
forms_ddl(command);
HTH
Günter
watsonr4_at_my-deja.com schrieb:
> Hello,
> I posted here a few weeks ago, but never got a response, so I thought
> I'd try again.
>
> I'm using Oracle Forms 4.5 and I need to call various stored procedures
> in the Oracle database. However, I cannot hard code the stored
> procedure names in the form (I could, but this way would make things
> MUCH simplier). I can set a variable equal to the package.procedure I
> need to call, but cannot figure out how to call it using only a
> variable name. Here is how I'm setting the variable:
>
> command :=
> check_rec.package||'.'||check_rec.proc||'(:range.start_login,:range.end_
> login)';
>
> Is it possible to call a stored procedure in Oracle Forms using a
> variable name???
>
> Thanks,
> Ron Watson
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 15 1999 - 11:42:29 CST