Anyone has some good example of 4D using PLSQL. I found a v2004 old example 
that will certainly be helpful.
Any example would be appreciated. I am starting learning OCI. So allis totally 
new for me.

How would I send the statement below. I am using a PLSQL bridge that was 
created to replace DDE tool. Looking at this,
I do not even know how to translate these commands.  "requete.path_put per” for 
example.
might
This is what I need to translate in 4D OCI.

DECLARE
   FUNCTION composer_requete_info_cours
   
   RETURN pljson IS 
      requete pljson;
   BEGIN
      requete := pljson();

      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_INSTANCE,    'cet');    
                -- Instance
      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_DELAI_ATTENTE, 20);     
          — Waiting delay

      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_SERVEUR, 
'srvacademique');          -- Server
      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_SERVICE ,  
'obtenir_info_cours.2' );  -- Service

      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_PARAMETRES || '[1]', 
'POL1301');
      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_PARAMETRES || '[2]', 
'POL1502'); 
      requete.path_put( reg_se_pass_cli_pkg.SERV_A_PATH_PARAMETRES || '[3]', 
'POL1601'); 

      RETURN requete;
   END

I am just trying to be efficient as I am starting looking into this. My 
question might be very obvious for some of you.
Any help is appreciated.

Luc Devar


**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to