Search results for query: *

Hi eh171 - don't know if this is any help as background info. SQL date datatype includes time as default - convert it to a string using a format such as 'HH24:MI:SS' (eg. using TO_CHAR() or similar) to see the time. If you are retrieving a string, you may be missing the (optional) date. Just...

Are you trying to set the text before the TextField has been instantiated ? Or before class2 itself has been instantiated ? Try checking the sequence of events. If none of the above, check the string has been initialized (give it a dummy value if necessary).

Is DMC part of a package ? If so, you'll have to run it from the parent directory and run it as '[package_name]/DMC'

How about setOpaque(true) as well ? (Slap).

I *think* it will depend on the JDBC driver you are using. There are likely to be several available for Oracle, with different specs. If not, you might consider SQLJ that they were pushing a while ago. (Not sure if it ever caught on though).

http://forum.java.sun.com/thread.jsp?thread=345021&forum=54&message=1425376

Sun's own tutorials are OK (avail as book or web). The online versions are quite handy for quick reference, but I find the style a bit chatty. Still, it's free.

I'd suggest getting a good Swing tutorial (or check out Sun's online tutorial). Chances are you've just misunderstood what's happening. Assuming you've setup a pane with a vertical BoxLayout to hold each row of buttons, you'll then need several horizontal BoxLayout panes (one for each row) to...

Sounds like it can't "see" the driver files. The manual says "... the SQL*Net driver is not loaded into memory or there is a mismatch of the version of the driver." Have a look at the Oracle registry settings and the Path environment variable: it uses them to find its programs.

Has anyone managed to control Excel from Oracle Forms 6.0 ? I have searched the Web and I can't get anything to work past starting Excel: the Forms 4.5 examples don't seem to work with 6.0. Any advice would be appreciated !

The default value is optional - the DECODE() returns NULL if no values<br>matched.

Mike, the PL/SQL structure you give is correct, but it is possible to<br>embed one block inside another in the way Steve has. One reason would<br>be to give a routine it's own set of local variables, but it's not<br>used very often and seems a bit pointless in this case.<br>Also, I don't think...

Just a guess - are any of your values NULL ? The result of any numeric<br>operation involving a NULL value is NULL.<br><br>Try putting NVL(column, 0) around anything not defined as NOT NULL.<br><br>This is always the first think I check when it happens to me.

If you mean from within SQL*Plus:<br>'SET DEFINE ON' and then prefix your variable names with '&', eg.<br>&nbsp;&nbsp;&nbsp;SELECT column1<br>&nbsp;&nbsp;&nbsp;FROM&nbsp;&nbsp;&nbsp;table<br>&nbsp;&nbsp;&nbsp;WHERE&nbsp;&nbsp;column2 = '&my_variable'<br>SQL*Plus will prompt you for the value...

Maybe the Trigger doesn't have access to the ALTER ANY USER permission&nbsp;&nbsp;(or whatever it's called).