Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why cant a PL/SQL function be used in an SQL Cursor?

Status
Not open for further replies.
zealand

zealand

Technical User
Sep 17, 2001
5
US
I have a PL/SQL stored procedure and function, both written in dba studio (oracle 7i), that i have copied into Oracle Reports 9i as program units. However when i compile the procedure i get an error message saying i cannot use the other function in the sql cursor part of the procedure. the cursor goes something like:

SELECT PART_NAME(PART, QTY) AS X_PART,

Where PART_NAME is the function.

Any ideas why i get this error?





 
Status
Not open for further replies.

Similar threads

Rank247
  • Locked
  • Question
I have a nested query which I want
Replies
0
Views
119
Rank247
Rank247
Jilly777
  • Locked
  • Question
Using function in SQL Query
Replies
0
Views
61
Jilly777
Jilly777
rrenda
  • Locked
  • Question
SQL Union only returns partial data
Replies
0
Views
97
rrenda
rrenda
csphard
  • Locked
  • Question
sequence in which queries run in the data model
Replies
3
Views
137
csphard
csphard
thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
215
thatgirl100
thatgirl100

Part and Inventory Search

Sponsor

Back
Top