Recent content by stefes007

found the solution: you have to throw a exception inside the trigger, and the connection will be killed. It doesn't work if you have the DBA role. Stephane. Dekeyzer Stephane. Belgium :)

Try to export your tables by small groups. try exp HELP=y there are some parameter : FILESIZE maximum size of each dump file or try QUERY select clause used to export a subset of a table Dekeyzer Stephane. Belgium :)

Hi, i'm trying to write a logon trigger that would refuse incoming connection from user externally authenticated from a non trusted server list: there are too many risks that someone root on a machine can create an account scott on that machine to logon externally as scott on oracle. My...

Hi, I need to get a sequence.nextval from an oracle sequence for a form in access. Access is already connected to this oracle database because there a re linked tables, but i d'ont have any idea how to submit queries as "select sequence.next into :bob from dual" ... Thanks for your help ...

I use SQL Worksheet 1.6.0 with an Oracle DB 8.0.6: My problem is that i have an azerty keyboard, but the program is like if i was with a qwerty keyboard. I have a belgian (Point) keyboard. All others applications on my computer works well, except that one... Does anyone has an idea how to...

that's what we are finally gonna do ... thanks 4 your help ... we had problems to find the solition because one script was a cgi, and the other one a php .... Dekeyzer Stephane. Belgium :)

good morning, I have a forms, with about 198 cells, <form name=&quot;form1&quot; method=&quot;POST&quot; action=&quot;reg_prog.php&quot; onSubmit=&quot;return validate(3,99)&quot;> and I would like to call two cgi-scripts: reg_prog.php and CGIBUL.cgi. I've already tried : <form...

thanks a lot, i finally choose that solution: <IMG SRC=&quot;nexts.gif&quot; border=0 onClick=&quot;recopiecoltab(0)&quot;> it works perfectly. Dekeyzer Stephane. Belgium :)

I have a HTML page with form to fill. Under those fields, there are images which fill automatically some fields when we clic on it. Here is the code: <a href=&quot;#&quot; onClick=&quot;recopiecoltab(0)&quot;> <IMG SRC=&quot;nexts.gif&quot; border=0></a> When I clic on that image the page...

you could give access to your users to a view of the tables they need ( if these tables are joinable ) and then make an alias on the view. Dekeyzer Stephane. Belgium :)

do you use your JoptioPane.showMessagedialog with null as first parameter ? Try that ... maybe it'll solve it... Dekeyzer Stephane. Belgium :)

I know some solutions for you: you can always do: spool c:\windows\desktop\aa.lis or in unix spool /home/me/a.lis second solution is in windows : Right click the icon of SQL*PLUS -> Properties -> Shorcut and change the start in filed: the directory you write in there will be the start...

Hi espanolito, Thank you for you for your help. I'm gonna try your method: for the moment, i've found another solution: public void paint(TiledImage ti, Positioner pos){ Graphics g = ti.getGraphics(); Graphics2D g2 = (Graphics2D)g...

Unfortunably, the database engine doesn't write the records in an ordered method: you should then use a fourth column that you would implement by a trigger which would insert into that column the max value of that column + 1. Then what you could do is: select * from table_name where rownum =...

up please, read-it, tell me sugestions ... It's very important !