how to use select clause in assignment

[joy]

I am writting a procedure, i am using a table:
part(empno,...,partid,..). I already know the partid, and I need to
know empno so I can use it to invoke another procedure--like
empb(myid). part of the code like:
myid =
(select empno
from part
where partid = part_id;);
and I started the procedure, it gave me:
15/16 PLS-00103: Encountered the symbol "SELECT" when expecting one
of
the following:
( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe

17/39 PLS-00103: Encountered the symbol ")"
what should I do? Thanks for help!

[mcstock]

look in the first chapter of the PL/SQL Users Guide under 'Assigning Values
to Variables''

you need to user the SELECT INTO syntax

-- mcs

"joy" <jo******@yahoo.com> wrote in message
news:35**************************@posting.google.c om...
| I am writting a procedure, i am using a table:
| part(empno,...,partid,..). I already know the partid, and I need to
| know empno so I can use it to invoke another procedure--like
| empb(myid). part of the code like:
| myid =
| (select empno
| from part
| where partid = part_id;);
| and I started the procedure, it gave me:
| 15/16 PLS-00103: Encountered the symbol "SELECT" when expecting one
| of
| the following:
| ( - + case mod new not null others <an identifier>
| <a double-quoted delimited-identifier> <a bind variable> avg
| count current exists max min prior sql stddev sum variance
| execute forall merge time timestamp interval date
| <a string literal with character set specification>
| <a number> <a single-quoted SQL string> pipe
|
| 17/39 PLS-00103: Encountered the symbol ")"
| what should I do? Thanks for help!

[Christine]

like this,

EXECUTE IMMEDIATE 'select empno from part where partid = '||part_id into myid;

[Frank]

Christine wrote:

like this,

EXECUTE IMMEDIATE 'select empno from part where partid = '||part_id into myid;

Use BIND variables:
EXECUTE IMMEDIATE 'select empno from part where partid = :a'
using part_id
into myid;
--
Regards, Frank van Bortel