• IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • to calculate last business day for each month for corresponding to any given date for last five years

    Hi , i have created a function to calculate last business date for each month for 1 year . Now, I want to modify code to find out last business day for last 5 years. Please suggest me what changes i need to made in code . CREATE OR REPLACE FUNCTION LAST_MONTHLY_BUS_DATE_FOR_YEAR (P_DATE in date )...

    Ashu15 pointsBadges:
  • oracle forms

    i'm trying to withdraw data from a form and insert it into a table... i've managed to create the process linked to the creation button (and the button of course), i 've tested it (it works) but i can't figure out what to do to GET the data from the form... the form consists of 3 items textfield...

    pforos220 pointsBadges:
  • Oracle form problem…

    hi there... i'm a noob at oracle and i try to withdraw data from a form in order to insert them to a table... here's what i have to do... i have a form which is for the user to provide 'name', 'address1', address2' and 'city'. the last one is a SelectList item! after the 'submit' button is pressed,...

    pforos220 pointsBadges:
  • Oracle Forms Query-Only Mode

    How can I find out if the current form is running in query-only mode.

    Cmccaffer10 pointsBadges:
  • error iexplorer

    i have same errors such mr tdmcolumbus i tried step by step what you told him to do, but still error the problem is : sometime IE work ,sometime display error in addition this error: res://ieframe.dll/acr_error.htm#handasa.com,http://server.handasa.com:8889/forms/frmservlet?

    Army125 pointsBadges:
  • creating procedure for searching in oracle 8.0.6

    how can i create a procedure to search records in oracle 8.0.6...i m using vb.net 2008 as frontend application

    Viralllll5 pointsBadges:
  • problem in create connection from forms 6i to oracle 9i on the same machine

    i installed oracle 9i on a machine succesfuly then i installed forms 6i on the same machine what can i do to connect from forms to oracle

    Weswes5 pointsBadges:
  • ORA-01031 Insufficient privileges

    I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

    SRDBA5 pointsBadges:
  • Delphi application freezing on search

    We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

    Archarish5 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • How can we pass Oracle username/password programmically?

    i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.

    Bina30 pointsBadges:
  • How can we call different canvases within one window?

    i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.

    Bina30 pointsBadges:
  • How user parameters are created in Oracle Reports 10g

    how user select the parameter from the parameter list and how it is created

    Nak7865 pointsBadges:
  • Query for tab canvas block

    I have a Form with a tab canvas for the detail and a multi row master block. when scrolling through the rows in the master block the detail block (tab canvas) isnot executing the query (only by steping on the detail block is the query preformed)

    Ifatgat5 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Can I run Seconds on an Alert in Oracle Forms 6i

    I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.

    SuperRad40 pointsBadges:
  • automatic go next field without enter keyboard key oracle form 6i

    hi , i facing problem with oracle 6i form ,what is the code for automatic go next field without enter keyboard key (not build in like go_item(xxx) or next_item) my code is working only when ENTER key pressed but i don't want press key, i using form for get external data from other database it will...

    Kutub50 pointsBadges:
  • Please help . What I am doing wrong

    Dim cmd As OracleCommand Dim ds As DataSet Dim dv As DataView Dim da As OracleDataAdapter = New OracleDataAdapter ' This does not work.. which is what I need, Country and State are entered by the user - cmd = New OracleCommand("Select state_code, state_name, state_status" & _ " FROM m_state" & _ "...

    Dax70 pointsBadges:
  • Appeon with Oracle

    How to Configure Oracle Data Base with Appeon.

    Yash1215 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following