Recent content by hedub

Thanks a lot!! Great forum. :)

Yes, but you do need && named literals for using it in a prompt. Example: accept s_sete prompt 'Choose seat:' prompt accept s_rad prompt 'Choose row:' prompt ?? what i need is the outvariable from procedure Finn and put them in s_sete... etc.

Hi, thank you all for the input. Let us say you can only order one ticket at a time. That means we leave out the issue when a family of seven comes to the boxoffice. And I also know that it would be a good aproach to rate each seat for dealing with output of the best combination of available...

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

The thing is.. I have only one user with insert, update, delete etc on the sqlserver. So how can I implement 3 users with different privilegies? And yes I mean some forms are visible/unvisible, menu items which are enabled/disabled. Since I cant create more users on the db, then i have to...

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

The scenario is like this: A fotballplayer scores goals. The function is supposing to return the 5 players that have most goals, a top 5 scorelist. Spillerid is the PK of the table SPILLER (in english: player) and are related to DELTAKELSE. DELTAKELSE (in english :to join, attending etc) is a...

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

Thank you! But.. the formatting of the xmloutput is rather messy.. The output is seen like this in a browser: Bodø/Glimt 1 3 1 3 Tromsø 1 2 1 3 Aalesund 0 0 0 0 Brann 0 0 0 0 Bryne 0 0 0 0 Lillestrøm 1 1 2 0 Lyn 0 0 0 0 Vålerenga 0 0 0 0 Viking 0 0 0 0 Molde 0 0 0 0 Odd Grenland 0 0 0 0...

Ops.. one more thing. The output only displays the first row, carps example shows all 3 but the output that I get is: SQL> select xmlgen.getXML('select * from test') from dual; XMLGEN.GETXML('SELECT*FROMTEST') --------------------------------------------------------------------------------...

I figured it out. It wouldnt work because XSU wasnt installed and configured for my database. The xsu contains the xmlgen and getxml packages. :) Thanks for all help! :)

You say returning a clob or a varchar2 .., can it return Smallint? Cause the table contains only attributes with this datatype. Thanks for all help so far! :)