RE: Passing Varialbles w/OAS & PL/SQL

David,
Your parameter CUSORD in your procedure can accept only one value. If you have multiple values stored and passing to it it will not handle it and hence ORA 6550 error. Change this parameter to PL/SQL table type.

let me know if u need more help.

Sandeep Dubey

-----Original Message-----
From: David Barbour [mailto:DBarbour_at_connectsouth.com] Sent: Tuesday, May 16, 2000 6:05 PM
To: Multiple recipients of list ORACLE-L Subject: Passing Varialbles w/OAS & PL/SQL

Here I sit, broken-hearted......

        (It's the reference to "passing" that got to me. Sorry, this problem is driving me up a wall!)

Hey Guys and Gals,

Could anyone shed some light on this for me? I'm getting date from a form. If the count of the number of orders for the customer equals one(1), I execute the following:

        OWA_UTIL.REDIRECT_URL('orderreview?tcusnum='||v_customer_number ||
'&cusord='||NULL);

If there are multiple orders, I place them in an unordered href'd(is that a word?)list. Clicking the link sends you to the same place as above.

        htp.anchor2('orderreview?tcusnum='||NULL ||
'&cusord='||v_order_number,htf.listItem(v_order_number));

The procedure orderreview starts out with:

		CREATE OR REPLACE PROCEDURE orderreview(
		        TCUSNUM                   varchar2,
		        CUSORD                     varchar2)

I get the following error for both: OWS-05101: Execution failed due to Oracle error -6550 This is NOT a lot of help. The error screen does show my parameters passing. It tells me for instance: PARAMETERS: =========== TCUSNUM: 05001234567788 CUSORD:
This part is good, I think. Any ideas?
Sleepless in Austin
David A. Barbour

-- 
Author: David Barbour
  INET: DBarbour_at_connectsouth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).