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

Home -> Community -> Usenet -> c.d.o.server -> Re: Passing tablenamens as parameters to procedures

Re: Passing tablenamens as parameters to procedures

From: Fernando Carvalho <f.carvalho_at_mail.telepac.pt>
Date: Tue, 18 Aug 1998 15:45:23 +0200
Message-ID: <6rc7u3$gnq$1@duke.telepac.pt>


Tony

>Forgot to close the cursor:

And also:

>> rc := dbms_sql.execute(hc);

must be:

    rc := dbms_sql.execute_and_fetch(hc);

followed by:

    dbms_sql.column_value(hc, 1, v2);

Regards

Fernando Carvalho Received on Tue Aug 18 1998 - 08:45:23 CDT

Original text of this message

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