Skip to main content
Contact a Moderator

Question

4
Replies
2483
Views
 Seshagiri Jogineedi (SeshagiriJogineedi) Commonwealth Bank of Australia Pega Lead System Architect
Commonwealth Bank of Australia
AU
SeshagiriJogineedi Member since 2013 3 posts
Commonwealth Bank of Australia
Posted: August 14, 2017
Last activity: September 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

Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 14 Aug 2017 8:49 EDT
Kautuk Shet (KAUTUKSHET) Company Name (optional) Consultant - CRM
Company Name (optional)
GB
This is compile time error, You will need to declare the variable 'TESTPROCEDURE' in your stored proc or function.
Posted: 4 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

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

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

Question

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

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

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

Question

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

Discussion

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

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 Solved

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

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