PL/SQL (MOSC)

MOSC Banner

Updating dunning letter flag using API

edited Jul 5, 2017 9:27AM in PL/SQL (MOSC) 5 commentsAnswered

Hi,

I had a requirement of updating dunning letter flag for a set of customers for which i had prepared an API to update the flag but while executing i am getting the below error.

DUNNING LETTER:Y

CUSTOMER ACCOUNT ID:392417

CUSTOMER ACCOUNT PROFILE ID:391419

Return Status:E

Error-ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Here is the script

CREATE OR REPLACE PROCEDURE UPDATE_DUNNING_FLAG

(errbuf OUT VARCHAR2,

retcode OUT VARCHAR2)

IS

CURSOR DUNN_FLAG IS

SELECT hca.cust_account_id,

  hca.account_number,

  hp.party_name,

  hp.email_address,

  HPC.DUNNING_LETTERS,

  hpc.CUST_ACCOUNT_PROFILE_ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center