Good news: you can have lots of bind variables.

From: <DEEDSD_at_nationwide.com>
Date: Thu, 2 May 2013 15:54:40 -0400
Message-ID: <OF56645643.7E5E68A2-ON85257B5F.006C893D-85257B5F.006D6018_at_lnotes-gw.ent.nwie.net>

Bad news, this SQL statement caught a 4031. Only 17,819 binds. No, I didn't write it. Cursor_sharing was set to 'FORCE'. No, I didn't set it that way.
----- Current SQL Statement for this session (sql_id=5kctn2u58dh21) ----- select distinct "Union1"."Library" "Library", "Union1"."Read_HTML_Item"
"Read_HTML_Item", "Union1"."DESCRIPTION" "DESCRIPTION",
"Union1"."LONG_DESCRIPTION" "LONG_DESCRIPTION",
"Union1"."Document_Name_HTML_Item" "Document_Name_HTML_Item" from (select
distinct "DOCUMENT_ATTACHMENTS"."ATTACHMENT_NAME" "ATTACHMENT_NAME",
"DOCUMENT_ATTACHMENTS"."ATTACHMENT_ID" "ATTACHMENT_ID",
"DOCUMENT_ATTACHMENTS"."DESCRIPTION" "DESCRIPTION",
"DOCUMENT_ATTACHMENTS"."LONG_DESCRIPTION" "LONG_DESCRIPTION", case when
"DOCUMENT_ATTACHMENTS"."OBJECT_TYPE"=:"SYS_B_00000" then CASE WHEN(CASE

WHEN(CASE WHEN(CASE WHEN(CASE WHEN(CASE WHEN(CASE WHEN(CASE WHEN(CASE 
WHEN(CASE WHEN(CASE WHEN(CASE 
WHEN(OP_REGISTRY_MGR.GET_VALUE(:"SYS_B_00001") IS NULL) THEN NULL ELSE 

(:"SYS_B_00002"||OP_REGISTRY_MGR.GET_VALUE(:"SYS_B_00003")) END IS NULL) THEN NULL ELSE (CASE WHEN(OP_REGISTRY_MGR.GET_VALUE(:"SYS_B_00004") IS NULL) THEN NULL ELSE
(:"SYS_B_00005"||OP_REGISTRY_MGR.GET_VALUE(:"SYS_B_00006")) END||:"SYS_B_00007") END IS NULL) OR
(OP_REGISTRY_MGR.GET_VALUE(:"SYS_B_00008") IS NULL) --snip--
 T
HEN NULL ELSE (:"SYS_B_17804"||"SQL1"."URL") END||:"SYS_B_17805") END||:"SYS_B_17806") END IS NULL) THEN NULL ELSE (CASE WHEN(CASE W HEN(CASE WHEN("SQL1"."URL" IS NULL) THEN NULL ELSE (:"SYS_B_17807"||"SQL1"."URL") END IS NULL) THEN NULL ELSE (CASE WHEN("SQL1"."URL
" IS NULL) THEN NULL ELSE (:"SYS_B_17808"||"SQL1"."URL")
END||:"SYS_B_17809") END IS NULL) THEN NULL ELSE (CASE WHEN(CASE WHEN("SQL1
"."URL" IS NULL) THEN NULL ELSE (:"SYS_B_17810"||"SQL1"."URL") END IS
NULL) THEN NULL ELSE (CASE WHEN("SQL1"."URL" IS NULL) THEN NUL L ELSE (:"SYS_B_17811"||"SQL1"."URL") END||:"SYS_B_17812") END||:"SYS_B_17813") END||:"SYS_B_17814") END||:"SYS_B_17815") END||:"SYS _B_17816") END "Document_Name_HTML_Item", :"SYS_B_17817" "Library" from (select f.name00 as ATTACHMENT_NAME,

                f.file_id as ATTACHMENT_ID,
                f.detail_page_url as URL,
                f.description as DESCRIPTION,
                f.long_description as LONG_DESCRIPTION
              from      openpages.resources r1,
                openpages.bundlelists b,
                openpages.propertyvals pv,
                openpages.propertydefs pd,
                openpages.resrelationships rr,
                openpages.resources r2,
                openpages.rt_file f
              where     r1.resourceid = :"SYS_B_17818"
                and r1.fullpath not like :"SYS_B_17819"
                and b.versionid = r1.latestversion
                and pv.bundlelistid = b.bundlelistid

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 02 2013 - 21:54:40 CEST