PL/SQL (MOSC)

MOSC Banner

Creating Oracle Store Procedure

edited Jun 1, 2011 2:03AM in PL/SQL (MOSC) 2 commentsAnswered ✓
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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center