javascript - Error: pls-00103 encountered the symbol "<" -


i have error in procedure code in oracle apex.

pls-00103 encountered symbol "<"

i think saying not recognizing javascript google maps, i'm not sure. i'm trying create procedure called pl/sql, in oracle apex, let user use drag-able marker, , find geocode.

here's code:

create or replace procedure "show_location"(    map_div in varchar2 default 'map-canvas',    issue_street_address in varchar2,    issue_post_code in varchar2,    city in varchar2,    lat_item in varchar2,   long_item in varchar2)    a_map varchar2 (32000); begin    a_map :=  <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false"></script> <script type="text/javascript">     var map;     var marker;     var streetview;      function initialize(myaddress, mylat, mylng){         var mapoptions = {             zoom: 12,             maptypeid: google.maps.maptypeid.roadmap         }         map = new google.maps.map(document.getelementbyid('||''''|| map_div ||''''||'), mapoptions);         geocoder = new google.maps.geocoder();         geocoder.geocode({ '||''''|| 'address' ||''''||': myaddress}, function(results, status){             if (status == google.maps.geocoderstatus.ok){                  var markeroptions = {                     map: map,                     draggable: true,                     animation: google.maps.animation.drop,                     flat: false                     position: results[0].geometry.location                  }                  map.setcenter(results[0].geometry.location);                  marker = new google.maps.marker(markeroptions);                   google.maps.event.addlistener(marker, '||''''|| 'dragstart' ||''''||', function() {map.closeinfowindow();})                  google.maps.event.addlistener(marker, '||''''|| 'dragend' ||''''||', function(event){                     document.getelementbyid("'||lat_item||'").value=event.latlng.lat();                     document.getelementbyid("'||long_item||'").value=event.latlng.lng();                  });             }             else {                  document.getelementbyid("||map_div||'").interhtml = "no map data found address. did enter correct address?";             }         });     }   </script>;  --  sys.htp.p (a_map); exception     when others         re_aplication_error (-20000, 'error in show_location: ' || sqlerrm); end show_location;​

you haven't enclosed script string in single quotes:

   a_map := '<script type="text/javascript" ... ...     }   </script>';

or since script may contain quotes, can use quotes text literal syntax, don't have escape them:

   a_map := q'%<script type="text/javascript" ... ...     }   </script>%';

the tricky thing here picking quote delimiter; common 1 <, [, # etc. might appear in script anyway. i've gone % may need change you're sure won't appear in text.


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more