Re: Help me

From: DriftWood <drift_wood_at_my-deja.com>
Date: Fri, 15 Dec 2000 14:11:02 GMT
Message-ID: <91d8pj$sd1$1@nnrp1.deja.com>

PL/SQL isn't SQl...

CREATE OR REPLACE PROCEDURE GetEmp (PP IN Varchar2) IS
myrow EMP%ROWTYPE;
BEGIN
SELECT * into myrow FROM EMP WHERE ENAME = PP; END; The select has to have someplace to put the data...

--
-cheers

  DW

---

"It is a kind of good deed to say well; and yet words are not deeds.   -William Shakespeare"

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 08:11:02 CST