Home » Open Source » Programming Interfaces » PSP help
PSP help [message #280474] Tue, 13 November 2007 16:00 Go to next message
quakeworld2007@gmail.com
Messages: 9
Registered: October 2007
Junior Member
I am having trouble with this part of my psp


<%FOR list_row IN (SELECT first_name, last_name, position, staff_no FROM staff) LOOP
 staff_id := staff_rental(list_row.staff_no);%>



I am getting an error that the identifier staff_id must be declared.

Staff_rental is a function that counts the # of rentals that each employee has and it works correctly when I test it in sql developer.

My question is how do I declare it in a psp.

[Updated on: Tue, 13 November 2007 16:02]

Report message to a moderator

Re: PSP help [message #280529 is a reply to message #280474] Wed, 14 November 2007 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Error message says that
Quote:

identifier staff_id must be declared

Did you declare 'staff_id'?
Re: PSP help [message #280674 is a reply to message #280474] Wed, 14 November 2007 08:32 Go to previous message
quakeworld2007@gmail.com
Messages: 9
Registered: October 2007
Junior Member
I tried to declare it like this


<%staff_id NUMBER; %>



But i get an error the symbol := was substituted for "NUMBER"
Previous Topic: Perl Script To Call A Simple Oracle Stored Procedure
Next Topic: Using Arrays in PL/SQL Queries
Goto Forum:
  


Current Time: Sat Nov 23 18:08:01 CST 2024