Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Seshagiri Jogineedi (SeshagiriJogineedi)
Commonwealth Bank of Australia
Pega Lead System Architect
Commonwealth Bank of Australia
AU
SeshagiriJogineedi Member since 2013 4 posts
Commonwealth Bank of Australia
Posted: Aug 14, 2017
Last activity: Sep 26, 2017
Posted: 14 Aug 2017 7:53 EDT
Last activity: 26 Sep 2017 3:50 EDT
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

To see attachments, please log in.
Java and Activities

  • Sourabh Jain
Posted: 7 years ago
Posted: 17 Aug 2017 1:24 EDT
Seshagiri Jogineedi (SeshagiriJogineedi)
Commonwealth Bank of Australia
Pega Lead System Architect
Commonwealth Bank of Australia
AU

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
To see attachments, please log in.

Related content:

Question Solved

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

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question

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

Question Solved

There was a problem getting a list: code: 0 SQLState: 42703 Message: ERROR: column PC0.buddyname does not exist Position: 203

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 Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

Question Solved

There was a database problem when performing an RDBExecute: code: 0 SQLState: Message: Invalid column count. Cannot be less or equal to zero

Question Solved

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

Question Solved

trying to store an empty property ID to a database column that does not accept nulls: code: SQLState: Message:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice