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
1311
Views
SeshagiriJogineedi Member since 2013 3 posts
Virtusa
Posted: 3 years ago
Last activity: 2 years 11 months ago
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

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

Posted: 3 years ago

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 LinkedIn
Copied!