• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

error identifier 'EMPTY' must be declared

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
0
samir25
Asked:
samir25
1 Solution
 
fmonroyCommented:
is empty a string?
if yes you need enclose it with single quotes
0
 
samir25Author 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
0
 
fmonroyCommented:
empty is not recognized by the engine, to test:

select null from dual;
select empty from dual;
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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

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

Thanks,
Ravi
0
 
samir25Author Commented:
ok...i dont get any error on declaring without empty..but however i cannot see the webpage...bottom_line its not working
0
 
joebednarzCommented:
We've tried something like that in the past... essentially your DEFAULT clause should point to a function that returns an empty array...

XNAME in owa_util.ident_arr default Empty_Array()


FUNCTION Empty_Array()
RETURN owa_util.ident_arr
IS
   an_empty_arr OWA_UTIL.ident_arr;
BEGIN
   RETURN an_empty_arr;
END;
0
 
samir25Author 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
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now