PL/SQL (MOSC)

MOSC Banner

How to resolve ora-06532 subscript outside of limit error?

in PL/SQL (MOSC) 4 commentsAnswered ✓

We have Supplier portal where user can register themselves as Supplier. User has to enter few details like name , country , address, bank details and when they clicked on save it will trigger webservice and internally it will call our custom package which is having varray type input variables then we are reading the data from them and storing in our custom staging table. Whenever user enters value with & like in bank details , beneficiary name as 'Abcd&' or 'ABC &D' or 'ABC & D' . Our package is getting errored out with ora-06532: Subscript outside of limit.

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