SP2-0552: Bind variable "LIMIT" not declared. [message #662729] |
Wed, 10 May 2017 18:39 |
youngb912
Messages: 56 Registered: October 2007 Location: New York
|
Member |
|
|
I am getting error while trying to run a select against the oracle sys.dba_profiles view. Please see below:
SQL> desc sys.dba_profiles
Name Null? Type
----------------------------------------- -------- ----------------------------
PROFILE NOT NULL VARCHAR2(30)
RESOURCE_NAME NOT NULL VARCHAR2(32)
RESOURCE_TYPE VARCHAR2(
LIMIT VARCHAR2(40)
SQL> SELECT substr(profile,1,length(profile))||':'||
substr(resource_name,1,length(resource_name))||':'||
substr(resource_type,1,length(resource_type)) ||':'||
substr(limit,1,length(limit))||':'
profile:name:type:limit
FROM sys.dba_profiles;
SP2-0552: Bind variable "LIMIT" not declared.
|
|
|
|
|