Getting error message: ORA-06550: line 1, column 66: PL/SQL: ORA-01741: illegal zero-length identifier ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored<p>
This it is due to this somehow:<p>
SELECT to_char(mdate,'DD-MON-YYYY HH24:MI') a, <br>
to_char(mdate,'DD-MON-YYYY HH24:MI') b<br>
FROM s_timemeeting<br>
WHERE meetinglocationid = :P55_meetinglocationid<br><br>
Cause I am trying to save value with this date format and maybe it is not "willing to get registered" .. the format in table is DATE (where it is supposed to be saved at)
And here is "Debug" code:
<div>.01: </div>
<div>0.01: S H O W: application="201" page="55" workspace="" request="" session="2470785524346496"</div>
<div>0.01: Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: en-us</div>
<div>0.01: alter session set nls_language="AMERICAN"</div>
<div>0.01: alter session set nls_territory="AMERICA"</div>
<div>0.01: NLS: CSV charset=WE8MSWIN1252</div>
<div>0.01: ...NLS: Set Decimal separator="."</div>
<div>0.01: ...NLS: Set NLS Group separator=","</div>
<div>0.01: ...NLS: Set date format="DD-MON-RR"</div>
<div>0.01: ...Setting session time_zone to dbtimezone</div>
<div>0.01: NLS: Language=en-us</div>
<div>0.01: Application 201, Authentication: CUSTOM2, Page Template: 1828708879785838743</div>
<div>0.01: ...Session ID 2470785524346496 can be used</div>
<div>0.01: ...Application session: 2470785524346496, user=SERNIVA7348</div>
<div>0.01: ...Determine if user "SERNIVA" workspace "11123328002022248" can develop application "201" in workspace "11123328002022248"</div>
<div>0.01: Session: Fetch session header information</div>
<div>0.01: ...Metadata: Fetch page attributes for application 201, page 55</div>
<div>0.01: Fetch session state from database</div>
<div>0.01: Branch point: BEFORE_HEADER</div>
<div>0.01: Fetch application meta data</div>
<div>0.02: Computation point: BEFORE_HEADER</div>
<div>0.02: Processing point: BEFORE_HEADER</div>
<div>0.02: Show page template header</div>
<!-- /*Global JS Variables*/ var htmldb_Img_Dir = "/i/"; //-->
<!-- htmldb_delete_message='Would you like to perform this delete action?'; //-->
<form id="wwvFlowForm" name="wwv_flow" action="wwv_flow.accept" method="post">
<input id="pFlowId" type="hidden" value="201" name="p_flow_id" />
<input id="pFlowStepId" type="hidden" value="55" name="p_flow_step_id" />
<input id="pInstance" type="hidden" value="2470785524346496" name="p_instance" />
<input id="pPageSubmissionId" type="hidden" value="376789" name="p_page_submission_id" />
<input id="pRequest" type="hidden" name="p_request" />
<input id="pdebug" type="hidden" value="YES" name="p_debug" />
<div>0.02: Computation point: AFTER_HEADER</div>
<div>0.02: Processing point: AFTER_HEADER</div>
<div>0.02: ...Process "Fetch Row from S_DISTRIBUTORMEETING": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:S_DISTRIBUTORMEETING:P55_MEETINGID:MEETINGID</div>
</form>
Message was edited by:
Hrefna
Message was edited by:
Hrefna