Re: Table name as input: HOW

Hello,

if you where connected to the database with your C program then you have with DBMS_PIPE the possibility to send the return value into a named pipe.

Your procedure is waiting until the pipe is filled with the especially package...

Markus

Norhamizan Arifin <mizan_at_mimos.my> schrieb in im Newsbeitrag: 37717ED2.30D72AE1_at_mimos.my...
> Hi!
>
> Thank you very much.
>
> I have 1 more question actually, you know in UNIX prompt we can run a
> program by passing 1 parameter get a return value. The program is
> created n C.
> Eg:
>
> crypt(word, result);
>
> Do you think that this can be done in PL/SQL? May be in form or
> procedure?
> If can how? Som say to you use DBMS_PIPE. how?
>
> Thanks in advance,
>
> ../Mizan
>
>
> Mark G wrote:
> >
> > You will have to use dbms_sql. Create your query string at runtime and
pass
> > it into the dbms_sql package. All good books should have a section on
> > dbms_sql.
> >
> > Mark
> >
Received on Thu Jun 24 1999 - 13:02:52 CEST