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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pipelined Procedure with Named Parameters

Status
Not open for further replies.
Dagon

Dagon

MIS
Jan 30, 2002
2,301
GB
Has anyone tried using table/pipeline procedures with named parameters ? i.e.

SELECT * FROM table(package.myproc(my_param=>'xxx'))

I get the error ORA-00907, but it works if I remove the "my_param=>". It looks as if it's not supported.

Database version is 9.2.0.6.0.
 
Sort by date Sort by votes
My understanding is select statements do not support reference by name. Reference by location must be used.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
689
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
750
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
835
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
183
TheLazyPig
TheLazyPig
gooseriver
  • Locked
  • Question
UPDATE statement - with two tables
Replies
1
Views
128
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top