Search results for query: *

I need to fetch values from a procedure. The procedures name is Finn and its located in a package called Seter. Its no problem getting the OUT values in Finn like: declare l_rad NUMBER; l_sete NUMBER; begin l_rad:='&&s_rad'; l_sete:='&&s_sete'; if l_sete is null then...

Hi, I am making a small application in PL/SQL for handling ordering of movietickets at a cinema (i am a newbie to this). When you enter your wish for what seat on which row you want among available seats, the program does the rest by registering your information into the database. BUT if you do...

making a windowsapplication with different users with different privilegies, how can u do that? Lets say when exexuting the program a dialog box appears and asks for username and password. Depending on your priv you will be granted access only to spesific parts of the winapp. Any ideas?

I have several textfields, lets say forname, surename and telephone. With a click on a button I want to execute a stored procedure. The procedure inserts the values from textfields into a table. How do I program the click event so the procedure will run/ be executed?

I want to retrieve data from another combobox using a select statement. E.g you have a table for teams, lets say football. By using two comboboxes you select the teams that are going to play (registered in a table called match), and by doing so I want to the players (retrived from table players)...

Hi, my table "deltakelse" looks like this: CREATE TABLE DELTAKELSE ( gulekort Smallint, rodekort Smallint, scoringer Smallint, kampid Smallint NOT NULL, spillerid Smallint NOT NULL, CONSTRAINT PN_DELTAKELSE PRIMARY KEY (...

I need to generate xml from a table. How do I do this, and how to I spool or make an output file e.g xml from an oracle table? So when I run lets say test.xml (which is generated by oracle) in a browser it will display the table with row and column name and data.

Hi, i am a newbie when it comes to pl/sql and programming triggers and procedures etc. I have to tables, lets call them Tab1 and Tab2. I wish that the trigger will execute and update Tab2 after insert on Tab1. Most of the attributes are the same in Tab1 as in Tab2. Tab2 is for statistics. How...

I am trying to set up a project, but do not wish to use the microsoft sql feature. Instead I want to connect to an oracle db with odbc. Is that possible in access database prosject?

I am trying to use access as an userinterface with a oracle db. But I do not know how to connect access with oracle, or what to do when doing update, insert, delete etc. Can anyone help me?