Home » SQL & PL/SQL » SQL & PL/SQL » select from table
select from table [message #230508] Thu, 12 April 2007 02:52 Go to next message
sirhan
Messages: 1
Registered: April 2007
Location: Kuala Lumpur
Junior Member
hi,

Anybody know what's wrong with my code??

CREATE OR REPLACE PROCEDURE SELECT_USER (I_USERNAME IN VARCHAR2,I_PASSWORD)
AS
BEGIN
SELECT *FROM USER_INFO WHERE USERNAME=I_USERNAME AND PASSWD=I_PASSWORD;
END;
/


how can i select i row data?
if there is more than one data how i can fetch it?
and then how i'm going to retrive it using PHP
Re: select from table [message #230513 is a reply to message #230508] Thu, 12 April 2007 02:55 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
In PL/SQL you have to SELECT your columns INTO something. There's a link to the online documentation in the sticky (tips and tricks).

MHE
Re: select from table [message #230523 is a reply to message #230508] Thu, 12 April 2007 03:06 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PHP does not support direct "select * from ..."?

Regards
Michel
Previous Topic: ORA-00439: feature not enabled: OLAP Window Functions
Next Topic: pl/sql tables versus global temporary tables
Goto Forum:
  


Current Time: Fri Dec 09 15:47:06 CST 2016

Total time taken to generate the page: 0.27242 seconds