PL/SQL procedures -- Tarot and oracle forum.

[ Show ]

Support VoyForums

[ Shrink ]

VoyForums Announcement: Programming and providing support for this service has been a labor of love since 1997. We are one of the few services online who values our users' privacy, and have never sold your information. We have even fought hard to defend your privacy in legal cases; however, we've done it with almost no financial support -- paying out of pocket to continue providing the service. Due to the issues imposed on us by advertisers, we also stopped hosting most ads on the forums many years ago. We hope you appreciate our efforts.

Show your support by donating any amount. (Note: We are still technically a for-profit company, so your contribution is not tax-deductible.) PayPal Acct: Feedback:

Donate to VoyForums (PayPal):

[ Login ] [ Contact Forum Admin ] [ Main index ] [ Post a new message ] [ Search | Check update time ]

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Date Posted: 10:02:09 08/24/04 Tue
Author: Ahmed
Subject: PL/SQL procedures

Hello everyone,

i need to know how i can create a PL/SQL procedure without using INSERT INTO. for instance, if i have the following SQL query:

------------------------------------------------------------ -------

SQL>SELECT address

SQL>FROM employee;

------------------------------------------------------------ -------

And if i want to perform the same SQL query in PL/SQL i need to write a code like:

SQL>CREATE OR REPLACE (procedure name) IS

2 BEGIN

3 SELECT address FROM employee

4 COMMIT;

5 END (procedure name);

6 /

Warning: Procedure created with compilation errors.

SQL> show errors;
Errors for PROCEDURE PROCS:

LINE/COL ERROR
-------- ----------------------------------------------------------
3/2 PLS-00428: an INTO clause is expected in this SELECT statement
Hello everyone,
i need to know how i can create a PL/SQL procedure without using INSERT INTO. for instance, if i have the following SQL query:

SQL>SELECT address

SQL>FROM employee;
------------------------------------------------------------
And if i want to perform the same SQL query in PL/SQL i need to write a code like:

SQL>CREATE OR REPLACE (procedure name) IS

2 BEGIN

3 SELECT address FROM employee

4 COMMIT;

5 END (procedure name);

6 /

Warning: Procedure created with compilation errors.

SQL> show errors;
Errors for PROCEDURE PROCS:

LINE/COL ERROR

----------------------------------------------------------
3/2 PLS-00428: an INTO clause is expected in this SELECT statement

i need your help before the first 3rd of September. If you can contribute with any information that might be of any help or might trigger a new idea to make this PL/SQL query work, please don't delay your answer then. Good luck to all of you.

Cheers
Ahmed

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Replies:

php and mysql -- smartcoder, 22:46:23 02/26/08 Tue