Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stefes007

    How to kill the session in a logon trigger

    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 :)
  2. stefes007

    Spanning Multiple Files with Imports/Exports

    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 :)
  3. stefes007

    How to kill the session in a logon trigger

    ...on oracle. My problem is that I don't know how to "kill" or exit current session in the pl/sql trigger ... I've been looking in the packages dbms*, I've tried to create an application error in that trigger, but nothing does it. Does anyone knows how to manage this ? Here is my trigger...
  4. stefes007

    getting sequence number from oracle

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

    SQL Worksheet

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

    good morning, I have a forms, wi

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

    good morning, I have a forms, wi

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

    a href=&quot;#&quot; moves my page scroll to the top

    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 :)
  9. stefes007

    a href=&quot;#&quot; moves my page scroll to the top

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

    multiple tables with same name but different owners

    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 :)
  11. stefes007

    JoptionPane

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

    SQL*PLUS: change default directory

    ...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 directory ... In unix, the start...
  13. stefes007

    JAI Graphics2D.drawImage

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

    Getting the last record in a table.

    ...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 = (select count(*) from table_name) order by your_new_column OR select * from table_name where your_new_column =...
  15. stefes007

    JAI Graphics2D.drawImage

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

    Creating a table from query results

    Hi, sorry i forgot all_tab_columns is an oracle system table. Well, maybe your ODBC driver doesn't support the create table command ( if i do well remember, ODBC is only for DML ( data manipulation langage ) and doesn't work with DDL ( data definition langage )). You have to execute this query...
  17. stefes007

    Creating a table from query results

    you can always do it thru sql: create table yourtable as select table_name, column_name from all_tab_columns; ( adapt this with your sql order ). Hope i could help you.
  18. stefes007

    JAI Graphics2D.drawImage

    ...gif with transparent background, so i made my gif with a non-transparent background, but it doesn't resolve my problems: i'm also sure that the Toolkit works, because i've seen it detect that my gif size ( 64*64). Does anyone knows when this bug will be repaired ? Thanks in advance for your...
  19. stefes007

    memory full

    Dear all, sadly, i'm no more working in that office... I think they've found a solution. Anyway, thanks for your response. Happy new year 2002. DEKEYZER Stephane.
  20. stefes007

    Create table using btrieve file

    maybe some simple or double quote around the string c:\...

Part and Inventory Search

Back
Top