John,
try this:
procedure sp_Get_Load_data
(
i_employee_id IN s_employee.Employee_ID%type,
cur_Data OUT curResult
)
IS
p_uniqueid VARCHAR2(30) := '153708612';
p_domain VARCHAR2(30) := 'SalaryWageBasis';
begin
open cur_Data for
'SELECT a.CURRBASESAL_MONAMT,
(SELECT MIN(WKAB)
FROM S_TCORE_ENUM_MAPPING WHERE FINEOS_ENUM = a.CURSALWAGEBAS
and DOMAIN = :p_domain) AS SalaryAmount
from s_tocperson a, s_tcoreoffsets b, s_tcoredeductions c,
s_tcorefinancialdata d
where a.I = (select i from s_tocperson where uniqueid = :p_uniqueid) and
b.I_OCPERS_OFFS = a.i and
c.I_OCPERS_DEDS = a.i and
d.I_OCPERS_FIND = a.i' USING p_domain, p_uniqueid;
end sp_Get_Load_data;
Regis
-----Original Message-----
From: John Hartley [mailto:[Email Address Removed] Monday, June 30, 2003 3:29 PM
To: LazyDBA.com Discussion
Subject: Problems compiling
One of my developers wrote this and I am trying to insert it into a package,
but I am getting a compile error:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the
following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count c
The select by itself, works fine, can you please take a look and offer any
suggestions? I tried a GROUP BY function, but that didn't work
either..THanks!
procedure sp_Get_Load_data
(
i_employee_id IN s_employee.Employee_ID%type,
cur_Data OUT curResult
)
IS
begin
open cur_Data for
SELECT a.CURRBASESAL_MONAMT,
(SELECT MIN(WKAB)
FROM S_TCORE_ENUM_MAPPING WHERE FINEOS_ENUM = a.CURSALWAGEBAS
and DOMAIN = 'SalaryWageBasis') AS SalaryAmount
from s_tocperson a, s_tcoreoffsets b, s_tcoredeductions c,
s_tcorefinancialdata d
where a.I = (select i from s_tocperson where uniqueid = '153708612') and
b.I_OCPERS_OFFS = a.i and
c.I_OCPERS_DEDS = a.i and
d.I_OCPERS_FIND = a.i;
end sp_Get_Load_data;
****************************************************************
Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*****************************************************************
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************
Oracle LazyDBA home page