Re: DBMS_SQl.Parse problem
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 07 Jul 1999 12:28:05 -0700
Message-ID: <3783AA45.7A04BE41_at_exesolutions.com>
Date: Wed, 07 Jul 1999 12:28:05 -0700
Message-ID: <3783AA45.7A04BE41_at_exesolutions.com>
> I have not bound any variable because I am only inserting rows into a
> table, what variables do I need to bind.
As follows:
tCursor := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(tCursor, sqlstr, dbms_sql.v7);
DBMS_SQL.BIND_VARIABLE(tCursor,':SomeVal',TO_CHAR(XTval));
DBMS_SQL.BIND_VARIABLE(tCursor,':TheVal', x_rec.rowid);
RetVal := DBMS_SQL.EXECUTE(tCursor);
dbms_sql.CLOSE_CURSOR(tCursor);
Daniel A. Morgan Received on Wed Jul 07 1999 - 21:28:05 CEST