0.00400	0.00200	S H O W: application="116" page="33" workspace="" request="" session="2925749411408504"	4	

0.00600	0.00100	Reset NLS settings	4	

0.00700	0.03300	alter session set nls_language="AMERICAN"	4	

0.04000	0.00000	alter session set nls_territory="AMERICA"	4	

0.04000	0.00100	...NLS: Set Decimal separator="."	4	

0.04100	0.00000	...NLS: Set NLS Group separator=","	4	

0.04100	0.00100	...NLS: Set g_nls_date_format="DD-MON-RR"	4	

0.04200	0.00000	...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"	4	

0.04200	0.00100	...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"	4	

0.04300	0.00100	...Setting session time_zone to +03:00	4	

0.04400	0.00000	NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en	4	

0.04400	0.00100	Application 116, Authentication: CUSTOM2, Page Template: 5361230258790797	4	

0.04500	0.00100	...Session ID 2925749411408504 can be used	4	

0.04600	0.01000	...Application session: 2925749411408504, user=USER2	4	

0.05600	0.00100	...Determine if user "USER2" workspace "4776409892232709" can develop application "116" in workspace "4776409892232709"	4	

0.05700	0.00100	...Check for session expiration:	4	

0.05800	0.00100	Session: Fetch session header information	4	

0.05900	0.00000	...fetch session state from database	4	

0.06000	0.00100	fetch items	4	

0.06000	0.00100	...fetched 15 session state items	4	

0.06100	0.00100	Branch point: Before Header	4	

0.06200	0.00200	Fetch application meta data	4	

0.06400	0.00000	...metadata, fetch computations	4	

0.06400	0.00100	...metadata, fetch buttons	4	

0.06500	0.00100	Computation point: Before Header	4	

0.06600	0.00000	Processing point: Before Header	4	

0.06600	0.00100	...metadata, fetch item type settings	4	

0.06700	0.00400	...metadata, fetch items	4	

0.07100	0.00300	Show page template header	4	

0.07400	0.00000	Processing point: After Header	4	

0.07400	0.00000	Computation point: After Header	4	

0.07500	0.00300	...Process "Fetch Row from PRIMER1": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:PRIMER1:P33_ID:ID	4	

0.07700	0.00200	...Process "Get Next or Previous Primary Key Value": GET_NEXT_OR_PREV_PK (AFTER_HEADER) #OWNER#:PRIMER1:ID::::P33_ID:P33_ID_NEXT:P33_ID_PREV::::P33_ID_COUNT:	4	

0.07900	0.00000	...Session State: Save "P33_ID_NEXT" - saving same value: ""	4	

0.07900	0.00100	...Session State: Save "P33_ID_PREV" - saving same value: "62"	4	

0.08000	0.00200	...Session State: Save "P33_ID_COUNT" - saving same value: "7 of 7"	4	

0.08200	0.00000	Computation point: Before Box Body	4	

0.08200	0.00100	Processing point: Before Box Body	4	

0.08300	0.00300	Region: Primer1	4	

0.08600	0.00100	Item: P33_ID NATIVE_HIDDEN	4	

0.08700	0.00100	Item: P33_NAME NATIVE_TEXT_FIELD	4	

0.08800	0.00200	Item: P33_DATE_P NATIVE_DATE_PICKER	4	

0.09000	0.00100	Item: P33_ID_NEXT NATIVE_HIDDEN	4	

0.09100	0.00100	Item: P33_ID_PREV NATIVE_HIDDEN	4	

0.09200	0.00100	Item: P33_ID_COUNT NATIVE_DISPLAY_ONLY	4	

0.09300	0.00300	Region: Primer2	4	

0.09600	0.00300	show report	4	

0.09900	0.00100	determine column headings	4	

0.10000	0.00100	parse query as: ADMIN	4	

0.10100	0.00100	...Binding: :P33_ID value="81"	4	

0.10200	0.00100	print column headings	4	

0.10300	0.00100	rows loop: 15 row(s)	4	

0.10400	0.00100	report error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error	4	

0.10500	0.00000	Computation point: After Box Body	4	

0.10500	0.00100	Processing point: After Box Body	4	

0.10600	0.00100	Computation point: Before Footer	4	

0.10700	0.00000	Processing point: Before Footer	4	

0.10700	0.00200	Show page tempate footer	4	

0.10900	0.00000	Computation point: After Footer	4	

0.10900	0.00100	Processing point: After Footer	4	

0.11000	0.00100	Log Activity:	4	

0.11100	0.00000	v$sesstat.statistic# = 436: execute count=2	4	

0.11100	-	End Show Page

0.10500	0.00000	Computation point: After Box Body	4	

0.10300	0.00100	rows loop: 15 row(s)	4	

CREATE TABLE  "PRIMER2" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"ID_PRIM1" NUMBER, 
	"INFO" VARCHAR2(255), 
	"MIMETYPE" VARCHAR2(255), 
	"FILENAME" VARCHAR2(400), 
	"IMAGE_LAST_UPDATE" DATE, 
	"IMAGE" BLOB, 
	 CONSTRAINT "PRIMER2_PK" PRIMARY KEY ("ID") ENABLE
   ) ;ALTER TABLE  "PRIMER2" ADD CONSTRAINT "PRIMER2_CON" FOREIGN KEY ("ID_PRIM1")
	  REFERENCES  "PRIMER1" ("ID") ON DELETE CASCADE ENABLE;

SELECT 
  ID, 
  fullname, 
  '<img src=''' || apex_util.get_blob_file_src('P1_PHOTO', ID) || ''' height="50%" width="50%"/>' PHOTO, 
  FILENAME, MIMETYPE, IMAGE_LAST_UPDATE,
  group_id
FROM V_ATTENDEES

ALTER TABLE PRIMER2 ADD apex_util.get_blob_file_src  column-definition;

APEX_UTIL.GET_BLOB_FILE_SRC (
    p_item_name           IN VARCHAR2 DEFAULT NULL,
    p_v1                  IN VARCHAR2 DEFAULT NULL,
    p_v2                  IN VARCHAR2 DEFAULT NULL,
    p_content_disposition IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;