ORA-00922: missing or invalid option

The ORA-00922 is being originated from your Oracle server, I doubt if it has anything to do with datasource. Suggest you post/ try your pl/sql from sqlplus and see if it runs ok. Are you executing a apackage or a procedure or simple sql stmts.

I have successfully run the pl/sql from sqlplus.  The pl/sql executes a package as well as a function that is defined within the pl/sql.

pl/sql posted below:

declare
   rc                        integer := null;
   part                      char(20) := null;
   description            char(20) := null;
   um                        char(2) := null;

   procedure f_read_msg is
       binding_out pkgsys_svc.binding_type;
       msg_rule_type varchar2(32);
       msg_event     varchar2(32);
       msg_object    varchar2(32);
       msg_attribute varchar2(32);
       i integer;
       rc integer;
       dte date;
       nbr number;
       nbr_out number;
       sqlerr integer;
       msg_text varchar2(512);
       msg_exc varchar2(8);
       msg_type varchar2(10);
begin
       i := 0;
       While i = 0 LOOP
       i := pkgsys_svc.read_message(binding_out, msg_type, nbr_out, sqlerr,
                                    msg_exc, msg_text, dte);
          if i = 0 then
             dbms_output.put_line('rule_type: ' || binding_out.rule_type);
             dbms_output.put_line('    event: ' || binding_out.event);
             dbms_output.put_line('   object: ' || binding_out.object);
             dbms_output.put_line('attribute: ' || binding_out.attribute);
             dbms_output.put_line(' msg_type: ' || msg_type);
             dbms_output.put_line('  nbr_out: ' || nbr_out);
             dbms_output.put_line('  msg_exc: ' || msg_exc);
             dbms_output.put_line(' msg_text: ' || msg_text);
             dbms_output.put_line('      dte: ' || To_Char(dte, 'YYYYMMDD'));
          end if;
          if not (i = 0 or i = 1) then
             dbms_output.put_line('read_message rtn: ' || i);
          end if;
       End LOOP;
   end f_read_msg;

Begin
   part := '11W1000002';

   rc := addpart.exec_all (
         part,
         description,
         uom
         
);

   f_read_msg;
   rc := pkgsys_tec.Exec_All('');
   dbms_output.put_line('Sync RC = ' || rc);
   rc := pkgsys_tec.Exec_All('COMMIT');
   dbms_output.put_line('Commit/Rollback RC = ' || rc);
   f_read_msg;

End;
/

The PL/SQl block wld be executed via a procedural call from CF to Oracle

from CF u need to call this Procedure using CFStoredProc & CFProcParam - so as to execute ur procedure ... use that instead of using CFquery to do ur job ...

hth

K'Rgds
Anand

I receive the same error message when assigning the sql to a variable and then outputing the variable contents within the cfquery.

could yourun a very simple anonymous block to rule out any setup issues.