Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql error (linux,apex)
pl/sql error [message #423663] Sat, 26 September 2009 03:49 Go to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
for i in 1..apex_application.G_F01.count
loop
apex_collection.delete_member(p_collection_name => 'ORDER',
p_c001 => apex_application.G_F01(i));
htp.p('item(s) removed ');
end loop;

1 error has occurred
ORA-06550: line 4, column 1: PLS-00306: wrong number or types of arguments in call to 'DELETE_MEMBER' ORA-06550: line 4, column 1: PL/SQL: Statement ignored

[Updated on: Sat, 26 September 2009 03:52]

Report message to a moderator

Re: pl/sql error [message #423665 is a reply to message #423663] Sat, 26 September 2009 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what is your problem in understanding "wrong number or types of arguments"?

Regards
Michel
Re: pl/sql error [message #423675 is a reply to message #423663] Sat, 26 September 2009 05:56 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Dig this link

regards,
Delna
Re: pl/sql error [message #423779 is a reply to message #423663] Mon, 28 September 2009 02:46 Go to previous message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
apex_collection package

Quote:

APEX_COLLECTION.DELETE_MEMBER(
    p_collection_name => collection name,
    p_seq             => member sequence number);

APEX_COLLECTION.DELETE_MEMBERS(
    p_collection_name => collection name,
    p_attr_number     => number of attribute used to match for the specified
                         attribute value for deletion, 
    p_attr_value      => attribute value of the member attribute used to 
                         match for deletion);

Previous Topic: avoid duplicate in select statement
Next Topic: Forall - need an example with multiple row
Goto Forum:
  


Current Time: Thu Sep 29 05:36:34 CDT 2016

Total time taken to generate the page: 0.12810 seconds