OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure (Version 10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure [message #412512]

Thu, 09 July 2009 14:47

AnnaOracle
Messages: 6
Registered: July 2009

Junior Member

Hello All,
taking a mentoring learning class w/o any mentors,

got stuk here:
CREATE OR REPLACE PROCEDURE GET_SALARY
( V_EMP_ID in STAFF.ID%TYPE,
V_SALARY out STAFF.SALARY%TYPE)
IS BEGIN
SELECT SALARY INTO V_SALARY
FROM STAFF
WHERE ID = V_EMP_ID;
END GET_SALARY;

error:

SQL> EXEC GET_SALARY(360,:g_salary);
BEGIN GET_SALARY(360,:g_salary); END;
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYSTEM.GET_SALARY", line 5
ORA-06512: at line 1

Also, are there any GUI tools like the development center in DB2?

Thanks a lot!
Anna.

Report message to a moderator

Re: Procedure [message #412514 is a reply to message #412512]

Thu, 09 July 2009 14:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Also, are there any GUI tools like the development center in DB2?
GUI won't solve PEBKAC induced situations.
Get JDeveloper from http://otn.oracle.com

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

which user owns table SALARY; likely not SYSTEM.

You really,really should not be running as SYSTEM user.

Report message to a moderator