Current Position:Home > global variable :global apex plsql

global variable :global apex plsql

Advertisement
  • How to create a session variable in Apex? Updated:10-11

    Hello colleagues, Is there someone do know how to create a session variable in Apex? How to get them? Thanks Best RegardsHello, What do you mean by 'session variable'? You mean something that stores the value int he users session state? I really reco

  • Variable scope in plsql package Updated:10-11

    When I run the following package, proc2 is always printing the value of i = 1 even though proc1 is incrementing the value of i correctly? Could any one explain to me what is the problem with this code? CREATE OR REPLACE PACKAGE test_pkg is PROCEDURE

  • Problem returning variables from dynamic SQL/PLSQL Updated:10-11

    Hi, I have a problem I am trying to solve using a very short piece of dynamic SQL or PLSQL but I am having problems getting the variable values out of the dynamic block. I have 16 counters whose names are made up of three variable parts - 'scheme', '

  • Problem with variables in dynamic SQL/PLSQL Updated:10-11

    Hi, I have a problem I am trying to solve using a very short piece of dynamic SQL/PLSQL but I am having problems getting the variable values out of the dynamic block. I need to increment a counter which could be any one of 16 counters I am using and

  • Output plsql variable to command window Updated:10-11

    I am executing a PLSQL stored procedure from my java class. I want to know how to output a variable within the PLSQL to the command window? thanksI don't understand the question. Are you telling us you don't understand how to use System.out.println(.

  • How do we handle multiple items in Apex? Updated:10-11

    Hi All, I have a requirement in to process the fileds data.I have a item by name as "Platts Lead1 to Platts Lead10" of type list items. By assuming end user can select entire fileds or we can first five items i.e "Platts Lead1 to Platts Lea

  • Using :APP_ID in the sql query in apex Updated:11-30

    Hi All, I am facing problem while using :APP_ID in the query for populating the Select list in apex. can any one suggest me how to use :APP_ID in the query. It is working fine in URL making.... in the javascript codes. And one more thing please put u

  • Apex 4.1 different font text in Reports Region and Interactive reporting Updated:10-11

    Hi everybody, In my APEX 4.1 page, I have two regions using the same ''Reports region" Template but font text are different. Why The first region is an interactive reporting. The second it's a report. I know that each one has his own data for sure bu

  • Get distinct values from plsql array Updated:10-11

    Hi, I have declared a variable as below in plsql proc. type t_itemid is table of varchar2(10); inserted set of items in to this using a program now i want distinct values from that array how can i get it.I am using 9i so i cannot use set operator and

  • Apex_util.prepare_url from PL/SQL (outside APEX) Updated:10-11

    Hello there, I have to create a job that sends emails with a link to a page with SSP actived and that requires authentification. I've read those threads from Dan and Omar and I wonder if this is still possible in APEX 4.2.1? Re: apex_util.prepare_url

  • Variable usage cheat sheet Updated:10-11

    I would like to have a cheat sheet that explains how to reference the different types of variables in Apex. When and how do you use 1. Substitution variables (&myvar) 2. Bind variables (:myvar) 3. Pound? variables (#MYVAR#) Could anyone please provid