Related content:

Question

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Question

Pega 73 Upgrade Error - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PXSAVEDATETIME": invalid identifier

Question

There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

Question

getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition

Question

Tried RDB-Delete for Pega Internal Table -- There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "*" Position: 8

Discussion

There was a problem getting a list: code: -206 SQLState: 42703 Message: PXCOVERINSKEY IS NOT VALID IN THE CONTEXT WHERE IT IS USE

Question

Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

Question

There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted

Question

SQL Error code: 29540 SQLState: 99999 while running the Report definition with unexposed column

Question

Problem writing an instance to the database: code: -302 SQLState: 22001

Question

4
Replies
1558
Views
Close popover
Seshagiri Jogineedi (SeshagiriJogineedi)
Virtusa
Software Development
Virtusa
AU
View Profile
SeshagiriJogineedi Member since 2013 3 posts
Virtusa
Posted: August 14, 2017
Last activity: September 26, 2017
Closed

There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7: PLS-00201: identifier 'TESTPROCEDURE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Getting the below error while executing the activity which have the RDB-Save which has Procedure in the Save tab of Connect SQL.

There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7: PLS-00201: identifier 'TESTPROCEDURE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Data Integration Java and Activities
Close popover
Moderation Team has archived post
Posted: 3 years ago
Close popover
Kautuk Shet (KAUTUKSHET)
Cognizant Technology Solutions
Consultant - CRM
Cognizant Technology Solutions
GB
View Profile

This is compile time error, You will need to declare the variable 'TESTPROCEDURE' in your stored proc or function.

Posted: 3 years ago
Close popover
Seshagiri Jogineedi (SeshagiriJogineedi)
Virtusa
Software Development
Virtusa
AU
View Profile

Here the Name "TESTPROCEDURE" is the stored procedure Name. while calling this procedure from the activity by using RDB-Save and Connect SQL i am getting error.


Below are the steps :


  1. Created activity rule

  2. Created a sample Stored Procedure named "TESTPROCEDURE"

  3. Used RDB-Save activity method in the activity

  4. Created the Connect-SQL rule

  5. Calling the SP from save tab of Connect-SQL from SAVE tab by using the below syntax

  6. Syntax -  \{ call TESTPROCEDURE \}

  7. attached the SP syntax
Share this page Share via LinkedIn Copying...
Copied!