oracle

  1. D

    Are JDBC select queries through a single connection less efficient that a proc containing those queries?

    If I open a single JDBC connection (for Oracle), and execute multiple select queries, will it be less efficient than calling a procedure that executes those queries, and returns the result in cursors? Edit: Sample queries are: select id, name from animals; select * from animal_reservoir where...
  2. N

    How to display php array

    This code will print result like this: test1@bnas.com.mytest2@bnas.com.my So how can I separate the result in 2 variable like email[0],email[1]??? $TEST='i192a'; $stid = oci_parse($conn, 'select email from BNS_NOTIFY_RECIPIENT where screen =:num0'); oci_bind_by_name($stid...
  3. J

    Oracle insert with many bind variables over WAN is very slow

    We have problem with slow insert statement using 40 bind variables as columns values. It runs several seconds when running over WAN link and we were not able to nail down the problem, until we used network analyzer. Every single execution of this prepared query required exchanging over 120...
  4. H

    Called through chef recipe, SQLPLUS unable to identify Oracle_Home environment variable in Windows 12R2

    I am running a chef recipe using chef client, which sets ORACLE_BASE, ORACLE_HOME and ORACLE_SID environment variables and then executes oracle sql scripts to create a database instance. Environment variables are set using a windows batch file (.bat) SET ORACLE_BASE=C:\<ora_base> SET...
Top