Search results for query: *

When an ALTER TABLE command adding a column with default value is executed, an UPDATE command will populate the new column with the default value, right? So, if there´s an "on" update trigger on this table, will this trigger be executed too?

Hi, I'm newbie on Unix, and I need to create a script renaming some files. The loop using the "for" command works fine unless there isn't a file to rename. For example: FLD="/test/fl*" for FL in $FLD do mv $FL /test/file.txt #other statements.... done So, if there's no file in the...

Hi, I just started using Delphi and I need to use a third part component, I already got the component source code. I can compile, install and place the package components on a form, but when I run the application this error is returned: [Error] File not found: 'xxxxx.R32' the error refers to...

Hi, I created a dynamic library for use as an external procedure, but the extproc returns the error: ORA-28595 - Invalid DLL path. I already checked the library path but it's right and the oracle user owns the directory and the library, has all the permitions needed by the OS. any sugestions?

Hi, I'm trying to use a OracleOCIConnection in a Java Stored Procedure, but the JVM seems to be 1.3, so it doesn't support this object, how can I update the JVM to 1.4 or just load the necessary classes? I tried to load the ojdbc14.jar to the system's schema but the user needs a...

Hi, I need to read data from a file, so I create a Java Stored Procedure, but when I call the procedure this error is returned: ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission /PublicFiles/tete.dxf read)...

Hi, I'm using an Oracle example to create an stored procedure to count how many rows there are in a table, the procedure works, but only to the user who owns the class, if another user calls the procedure the error ORA-00942 is returned, even if the user has execute grant to the Java class. Can...

Hi! I'm trying to access an object reference in a view in another schema, (connecting using a user that has just the connect attribute), this view is a union of two collections, it has the name and a reference to the address of the vendor and manufacturer, so I use the following code: dim...

Hi, I want to list diferente kind of files in a directory, for example *.txt,*.zip,... But I want to know if I can do it just once, instead of call the DIR function for each extension