Current Position:Home > global variable :global apex plsql

global variable :global apex plsql

  • 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

  • Binding Variable in Apex... Updated:11-30

    Hi, How do we check binding variable in Apex.. Anoo..Hi Anoo, Given that your text boxes appear to be dates, you may have to use TO_DATE(:ITEMNAME) in your query. For example: SELECT EMPNO, ENAME, HIREDATE FROM EMP WHERE HIREDATE BETWEEN TO_DATE(:P1_

  • APEX: Declare global variable in APEX Updated:11-30

    Hello All, Can anyone tell me how to declare global variable in Process(Pl/sql code) in Oracle APEX. Thanks, JitenThere is nothing like Global Variable that can be declared in Process in Apex. Look up Shared Components > Application Item. Maybe that

  • 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

  • Variables in Apex Updated:11-30

    Hi all, I have a little problem. I don't know how to define variables and use them again in APEX For exemple : I want to display which week of the year we are on an HTML Region the query is simple : select to_char(sysdate,'IW') from dual; But How can

  • Pass variable from apex to shell script Updated:11-30

    Hi, i am able to use apex button to run a db scheduler job and use the the job to run an OS bash script, but don't know how to pass an variable to the script from apex.Hi, Thansk for the reply. My scenario is 1. Apex page 1: Store List Report, click

  • Passing unix variable value to plsql block Updated:11-30

    hi.. i want to pass the value of a unix variable to a pl/sql block. I dont know how to go about it. My code is for all the files in the directory, ( say $i as the file name ) sqlplus -s <<! cmdp_rdev/[email protected] declare no number:= 0; BEGIN no :=

  • Using pipelined functions with bind variables in Apex... Updated:11-30

    Hy all: I have a table which has about 10 million records and it is hanging up the system when it is trying to retrieve the data from that table... so what I have done is I created a pripelined function and then trying to retrieve data using an SQL s

  • Apex Global Variable like D2K Updated:11-30

    HI, Previously my application was develop in d2k6i where i use global variable to keep user_id available in every forms... is it posbile to declare global variable in Apex ? Thanks Engr.M.K ChowdhuryJust to extend Andy's point a little further, you m

  • Create Global Variable Updated:11-30

    Hello developers, I need to create a global bind variable, which i can fill with a return value of a select statement. Can someone tell me how to do it, or send me a link, where global bind variables in APEX are explainedHi, Thanks for your informati

  • Replacement variables SQL Plus x PLSQL x APEX Updated:11-30

    How Can I use replacement variables SQL Plus, integrating with APEX ,PLSQL?This isn't going very well is it? Perhaps it has something to do with a lack of knowledge of the english language, that you don't explain your case more, but I'll try to rephr

  • 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