Oracle SP Fails when called from Apex form due to date format -


i have table inserting , updating data using procedure based on input parameters. procedure called oracle apex form. procedure works fine in oracle. when call apex form, procedure fail error. on analysis, found because of date format mismatch in value passed apex form , in oracle.

date format in apex form-->16-aug-2017

date format in oracle db-->2017-08-17

do need format input parameter in apex form before calling oracle procedure or need change format within procedure. please help.

apex treats item values strings e.g. '16-aug-2017'. if procedure calling expects date parameter need convert value before calling it. go against grain many people, in apex application happily use implicit conversion:

myproc (p_date => to_date(:p1_date));

this work regardless of date format setting in apex. alternative perform explicit conversion using prevailing apex date format this:

myproc (p_date => to_date(:p1_date, :app_nls_date_format));

but seems redundant me.

of course, procedure call going fail if value in p1_date not valid date in prevailing apex date format, should validate prior calling procedure. can using apex validation example. way have apex procedure layer accepts values strings, validates , converts them using common utilities, , calls main procedure.


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more