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

Quick (and hopefully simple) question:

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

In sqlplus I can do something like (trivial example):

variable n number
begin
  select max(key) into :n from xxx;
  dbms_output.put_line('Number = ' || :n); end;
/

where table xxx created as...
create table xxx (
key number primary key);

insert into xxx (key) values (1);
insert into xxx (key) values (2);
insert into xxx (key) values (3);

How to do the same with a procedure (function, package, etc)?

Thank you,
John

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 21 1998 - 16:46:42 CST