EasyCFM.COM ColdFusion Forums / Oracle Related Issues / error executing procedure

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: error executing procedure

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

epipko
01-25-2005 @ 1:35 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 278
Joined: Feb 2004

Hi all,
After we upgraded our test and prod to 9i, procedures that were geting called from Cold Fusion stopped working.
I am using the following code (which worked before):

     <cfstoredproc procedure="edi_jcp_855_p"
                      datasource="Titan">
          <cfprocparam type="In"
                          cfsqltype="CF_SQL_INTEGER"
                          value=#form.customer_purchase_order#>                         
          <cfprocparam type="In"
                          value=#form.department_id#
                          cfsqltype="CF_SQL_INTEGER">
          <cfprocparam type="In"
                          value=#form.po_date#
                          cfsqltype="CF_SQL_INTEGER">
          <cfprocparam type="In"
                          value=#form.accept#
                          cfsqltype="CF_SQL_CHAR">
     </cfstoredproc>

and getting the following error message:

Oracle][ODBC][Ora]ORA-06550: line 1, column 22: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated

We had simillar issue before trying to connect from Oracle 7 to 9i. When I login itno SQL*Plus on CF server, however, I see:

SQL*Plus Release 8.1.7.0.0

I think it has something to do with Oracle drivers/versions.
Does anyone know how to fix it. It is pretty urgent

Thanks,
Eugene


Website Designed and Developed by Pablo Varando.