We help IT Professionals succeed at work.

error identifier 'EMPTY' must be declared

samir25
samir25 asked
on
565 Views
Last Modified: 2013-12-19
hi
i want to define this array type in the procedure declaration

XNAME in owa_util.ident_arr default empty
and it gives me below error
Error(43,36): PLS-00201: identifier 'EMPTY' must be declared

how to declare this
Comment
Watch Question

Commented:
is empty a string?
if yes you need enclose it with single quotes

Author

Commented:
no for an array i think i need to asign default to empty just like we assign null..i want to know why it doesnt accept and what is the solution

Commented:
empty is not recognized by the engine, to test:

select null from dual;
select empty from dual;
CERTIFIED EXPERT

Commented:
I think this question has already been asked in a slightly different way!

https://www.experts-exchange.com/Database/Oracle/Q_20845043.html

Thanks,
Ravi

Author

Commented:
ok...i dont get any error on declaring without empty..but however i cannot see the webpage...bottom_line its not working
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
this one is an interesting solution. however, i resoved by passing a defautl value of 0 .. /data?0

ur solution is what i had wanted. i will try it one day
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.