RE: [sqr-users] Formal parameter '@P83' was defined as OUTPUT buttheactual parameter not declared OUTPUT.

["Knapp, Richard" <KnappR@umsystem.edu>]

And you do have the ODBC version of SQR?  

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Joe Johnson
Sent: Thursday, April 06, 2006 9:30 AM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Formal parameter '@P83' was defined as OUTPUT
but theactual parameter not declared OUTPUT.

Operating System.

The full error statement is:

[Microsoft][ODBC SQL Server Driver][SQL Server]Formal parameter '@P83'
was
defined as OUTPUT but the actual parameter not declared OUTPUT.

Thanks,

Joe 

Direct: (505) 798-6480 
email: joejohnson@ernesthealth.com

-----Original Message-----
From: sqr-users-bounces+joejohnson=ernesthealth.com@sqrug.org
[mailto:sqr-users-bounces+joejohnson=ernesthealth.com@sqrug.org] On
Behalf
Of Knapp, Richard
Sent: Thursday, April 06, 2006 8:22 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Formal parameter '@P83' was defined as OUTPUT
buttheactual parameter not declared OUTPUT.


Where does the error message come from?  Not SQR.  Operating system?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Joe Johnson
Sent: Wednesday, April 05, 2006 2:06 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: [sqr-users] Formal parameter '@P83' was defined as OUTPUT but
theactual parameter not declared OUTPUT.

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

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



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

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