Creating Oracle Store Procedure
I have created 263 out of 267 procedures. The last four will not compile. Here is one of them. Any help is appreciated!
Create or Replace Procedure psp_GetPayRate(
vResourceID in number,
aData out SYS_REFCURSOR
)
As
vPayRate number :=0;
vPayRatePer varchar :='';
r_ct number :=0;
Begin
Select Count(*) Into r_ct From tbl_LK_Resources Where ResourceID=vResourceID;
Select PayRate Into vPayRate From tbl_LK_Resources Where ResourceID=vResourceID;
Select PayRatePer Into vPayRatePer From tbl_LK_Resources Where ResourceID=vResourceID;
If r_ct > 0 or vPayRate=0 Then
Open aData For Select 0 as PayRate From Dual;
ElsIf lower(vPayRatePer) = 'hour' Then
Open aData For Select vPayRate as PayRate From Dual;
vResourceID in number,
aData out SYS_REFCURSOR
)
As
vPayRate number :=0;
vPayRatePer varchar :='';
r_ct number :=0;
Begin
Select Count(*) Into r_ct From tbl_LK_Resources Where ResourceID=vResourceID;
Select PayRate Into vPayRate From tbl_LK_Resources Where ResourceID=vResourceID;
Select PayRatePer Into vPayRatePer From tbl_LK_Resources Where ResourceID=vResourceID;
If r_ct > 0 or vPayRate=0 Then
Open aData For Select 0 as PayRate From Dual;
ElsIf lower(vPayRatePer) = 'hour' Then
Open aData For Select vPayRate as PayRate From Dual;
0