Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Simple SQL question
In article <cKRq4.353$CL6.3080_at_dfiatx1-snr1.gtei.net>,
"Rookie" <Rookie.Programmer_at_gte.net> wrote:
> I would like to use a procedure for a simple select statement, so that it
> can be called by the same name each time anywhere from an application. I
> would like to use something like this:
>
> CREATE OR REPLACE PROCEDURE GET_USER
> (
> USERNAME IN VARCHAR2,
> USERPASSWORD IN VARCHAR2,
> USERID OUT NUMBER
> )
>
> AS
>
> BEGIN
>
> SELECT TBL_USERS.USER_ID
> INTO USERID
> FROM TBL_USERS
> WHERE TBL_USERS.USER_NAME = USERNAME
> AND TBL_USERS.USER_PASSWORD = USERPASSWORD;
>
> END;
>
> Where each time the procedure get_user gets called from a java application,
> the user id will get returned when the username and the userpassword is
> given as parameters.
>
> Please help. Thanks in advance!
>
>
Your code looks fine to me. What is your question?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Feb 18 2000 - 00:00:00 CST