SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00911: Invalid Character ; System.data.oledb.oledbexception

658156Sep 4 2008 — edited Sep 4 2008

I have a the following code in my SSIS script component,

strUpdateQuery = "UPDATE V_TRANS_SDIPRCMST SET INT_DATE = SYSDATE,INT_STATUS = 'Y' WHERE ORG_LVL_NUMBER = " + intSiteID.ToString() + " AND INT_STATUS = 'N' AND INT_COUNTRY_CODE = 'PH'"
cmdUpdatePMMData.CommandText = strUpdateQuery
cmdUpdatePMMData.ExecuteNonQuery()

When i tried to execute the above code, it works fine in my development machine, when we try to deploye the same in the integration testing machine, the package throws an error

System.Data.OleDb.OleDbException: ORA-00911: invalid character at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket).

I am not having any clue why it is not working in test machine, which works in developement machine. Anything related to oracle version?
Any suggestions or solution would be appreciated.

Thanks
Dhivya S

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2008

Added on Sep 4 2008

4 comments

1,406 views