Home » Open Source » Programming Interfaces » PSP help
PSP help [message #280474] Tue, 13 November 2007 16:00 Go to previous 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

 
Read Message
Read Message
Read Message
Previous Topic: Perl Script To Call A Simple Oracle Stored Procedure
Next Topic: Using Arrays in PL/SQL Queries
Goto Forum:
  


Current Time: Fri Mar 29 09:18:17 CDT 2024