Oracle Development

Dear Carlos De Leon... Kindly help me out

Hi.... Dear Carlos De Leon You have told that i have to do that by saving the value of the parameter in the database and use it later when i need that.... Can you please help me out how can i do that.... we will have to pas as much parameters as the number of colums in the report.. caN you [leas...

A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)

whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want to show...

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...

How to create procedure in Oracle

I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID ...

Using INSTEAD OF Views in Oracle Forms 6i

I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...

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...

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...

Appeon with Oracle

How to Configure Oracle Data Base with Appeon.

iSQLPlus creating packages with multiple procedures in it

Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

Oracle Forms 6i Database Objects

I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you

Connectivity of Visual Basic 6 and Oracle 10g

Can u plzzz sugest me the code of how to connect Visual Basic6 and oracle 10g, I am facing problems while connecting. Plzz do reply at ur earliest. -Supriya

.NET connecting to Oracle 9i

Please Help. I am new to .Net. Using .Net 2003 Oracle 9i Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection("User Id=system;Password=dax856;Data Source=DMS") Dim...

Developing standalone Apps with Oracle Developer 10g

hai, i am new to oracle 10g development. can i build an application using oracle forms developer 10g and run it without deploying in the application server.(i.e without using oracle 10g Application Server) thanks np

Oracle Request Set Run Time Log File Posting

Hi Everyone, I am currently using the put_line to write information to the log file in Oracle. I don't get to see what is in the log file until the job finishes running. I would like to write to the log file and have the information available while the job is progressing (running) at any point...

Hiding a stacked canvas in Oracle 9i

how to hide the stacked cancas using a code in the oracle9i? i call the stacked using the form so the problem now is what code am i going to use to hide it in runtime! so that the user input will be on the content canvas and the stacked canvas will not be visible after i click a command! help.. any...

Looping Queries in Oracle using data from SQL Server

I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this?...

Default Types in Oracle Parameter Screen

I am adding my default parameters to my stage. In the default type drop down box I see Constant, Current Date, Current Time, Field, Profile, SQL Statement and Segment. I know what most of them mean but have questions on Field, Profile and Segment. I have tried searching the web for answers but came...

SQL query and Oracle database design help needed

Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

java.lang.NoClassDefFoundError

Hi, I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to the OC4J container. And everytime I access the webpage I get this error. 500 Internal Server Error java.lang.ExceptionInInitializerError at com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at...

Oracle Form Use As Web Page

I am a Oracle Form Developer 6i . I want to Apply My Oracle Form As Web Page. smply I want open my form through internet (as web-page)