| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Calling an Insert Stored Procedure in ASP
Ok, folks. Here's the deal. Basically, I have a Stored Procedure in
Oracle that inserts data into a table. Simple enough. I want to call
this sp from ASP, and here is the code:
InsertQuery = "'" & serial_num & "','" & payment_type & "', " & "'" & contract_num & "', '" & delivery_task_order & "', '" & invoice_num & "', '" & invoice_date & "', '" & invoice_entered & "', " & quantity & ", " & unit_price & ", " & shipping_price & ", " & travel_setup_price & ", " & parts_consumables & ", " & invoice_amount & ", '" & invoice_paid_date & "', " & total_remaining & ", " & total_award & ", '" & comments & "'"
Set cn = Server.CreateObject("ADODB.Connection") cn.open Application("CASSNET_ConnectionString") cn.execute("INVOICE_INSERT " & InsertQuery)
If I response.write InsertQuery to a webpage, copy and paste that into PL/SQL, the SP works fine. However, when I try to run the webpage I keep getting the following Error:
ORA-00900: invalid SQL statement
/Invoicing/invoicing.asp, line 82
Line 82 is the cn.execute line. Any ideas on what's causing this error and what can be done to correct it? Thanks in advance.
-Jason Received on Fri Jun 27 2003 - 06:24:49 CDT
 |
 |