Re: How to access sql table records in PL/SQL

I have same problem please let me know if you come to know the answer.

Thanks

News wrote in message <8ILG4.141$k5.63930_at_news.abs.net>...
>I am a new Oracle user. I want to display the SQL table records in PL/SQL
>procedure. For which I'm using following
>
>Declare
>v_FirstName varchar2(15);
>v_LastName varchar2(15);
>v_Salary number;
>
>Begin
>--Employee is table name & FirstName, LastName, Salary are the fields of
the
>table
>
>select FirstName, LastName, Salary into v_FirstName, v_LastName, v_Salary
>from employee;
>
>dbms_output.put_line(v_LastName || ' ' || v_FirstName || ' ' || v_Salary);
>
>End;
>/
>
>I have multiple records in the employee table. When I run the program I get
>error multiple records found.
>If anybody knows, Please let me know.
>
>Thanking in advance.
>
>Rajashri Jadhav
>
>
Received on Wed Apr 05 2000 - 14:25:45 CDT