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: Q: How to use bind variables in stored procedures, packages, etc.

Re: Q: How to use bind variables in stored procedures, packages, etc.

From: Kai Horstmann <horst_at_werum.de>
Date: Tue, 26 Jan 1999 22:38:41 +0100
Message-ID: <36AE35E1.C2190FF6@werum.de>


>
> How do you declare/use bind variables in stored (server side) plsql
> packages, functions, procedures, etc.?
>

Use them without the ":". Choose names for your variables that are unequal than the table columns so that the compiler can distinguish between table columns and PL/SQL variables.

Have you really EVER read anything about PL/SQL programming or seen any example?

Kai Received on Tue Jan 26 1999 - 15:38:41 CST

Original text of this message

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