Oracle via ADODB - Syntax error or access violation
Hejsa,Jeg får følgende fejl når jeg forsøger at afvikle følgende ASP:
===
Set DB_Connection = Server.CreateObject("ADODB.Connection")
DB_Connection.Open "dsn=TESTORACLE;UID="&OracleUser&";Pwd=**;"
DB_Connection.BeginTrans
sql = "ALTER TRIGGER CaptBUR_PendingAction disable;"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
sql = "UPDATE PENDINGACTION SET COMPLETEDATETIME = '96-01-01' WHERE BATCHID = "&BatchID&" AND COMPLETEDATETIME IS NULL;"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
sql = "UPDATE WEBPENDINGACTION SET COMPLETEDATETIME = '96-01-01' WHERE CORPPENDINGACTIONID IN (SELECT PENDINGACTIONID FROM PENDINGACTION WHERE BATCHID = "&BatchID&") AND COMPLETEDATETIME IS NULL;"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
sql = "execute CapRULEf_RejectSubmission("&SUBMISSIONID&")"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
sql = "execute CapSYNCcons_RejectionCopy("&SUBMISSIONID&")"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
sql = "ALTER TRIGGER CaptBUR_PendingAction ENABLE;"
DB_Connection.Execute (sql)
Response.Write (sql & "<br>")
DB_Connection.CommitTrans
DB_Connection.Close
set DB_Connection = nothing
====
Fejlen får jeg når den skal execute "execute CapRULEf_RejectSubmission("&SUBMISSIONID&")", som er et script i databasen.
Brugeren har adgang til det korrekte schema og rettigheder til at afvikle scriptet. Hvis jeg logger på i SQL*Plus med samme bruger og forsøger det samme er der ingen problemer.
Er der nogen der har et clue?
