[sqr-users] Formal parameter '@P83' was defined as OUTPUT but theactual parameter not declared OUTPUT.

["Joe Johnson" <joejohnson@ernesthealth.com>]

Greetings Group,

I have seen this error posted in the history for SQRUG, but none of the
posts seem to fit my error here.

We are using SQR for Peoplesoft 8.47 and MS SQL Server 2000.

I have a straightforward program that inserts Merit and Accomplishment data
from a csv file into 4 tables.  The majority of the fields that are inserted
for each table are obtained by doing a select on that table.

What I have run into is this:

If the CSV file has more than 50 rows in it, it bombs with the following
error:

Formal parameter '@P83' was defined as OUTPUT but the actual parameter not
declared OUTPUT.

The insert for '@P83' is this:

Begin-sql
insert into PS_JOB_JR
(Columns listed .....)
Values
......
......
,&JOBJR.FP_PT_END_DT  
......

Etc.

The value &JOBJR.FP_PT_END_DT is selected from PS_JOB_JR in a previous step.

Here's the part that gets me -- if I cut the input csv file to 40 rows,
there is no error.  If I run the rest of the file, as long as it is less
than 50 rows, there is no error.

My file parameters being set are:

#define RecLength  1500        
#define RecType    Vary

What gives?

There is no temp table involved, nor is there a stored procedure.  

Any help will be appreciated.

Thanks,

Joe Johnson
Software Developer
Ernest Health, Inc.
joejohnson@ernesthealth.com



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users