pl/sql in pro*cobol

From: Martin Meadows <mmeadows_at_indy.net>
Date: Wed, 06 May 1998 18:59:45 -0500
Message-ID: <3550F971.65A2@indy.net>

Hi,

I'm trying to compile the following pl/sql code inside a pro*cobol program (frankr's idea):

validate-emp-number.

   exec sql execute
   begin
   select 'x' into :placeholder

     from payroll_employee_master
     where emp_# = :emp-number-o;
   exception
     when no_data_found then
        :employee-number-flag := 0;

   end;
   end exec.

   I've tried several variations of this but I consistently    get
   "identifier 'payroll_employee_master' must be declared"    when I compile it.

   What's the problem? It's had me hung up for a couple of    hours and I'm bummed ...

   Thanks,
   Martin Meadows Received on Wed May 06 1998 - 18:59:45 CDT