I have PHP code that execute a stored procedure 10 times.If one stored procedure call fails, it sh开发者_高级运维ould continue on, and at the end commit the transaction.
I need to send HTML emails directly from oracle PL/SQL package. This works almost fine. I have problem with the fact that some of the data fetched from a table contain things like <S>, <L>
I\'m trying to add an attribute to an already existing Object Type in an Oracle 10.2.0.4 DB. The schema is valid, and everything is working before running the following statement:
I开发者_C百科s there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects?
I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These scripts are written by somebody else and are meant to be executed concurrent开发者_运维问答ly. All
I would like to restrict users from inserting more than 3 records with color = \'Red\' in my FOO table.My intentions are to A) retrieve the current count so that I can determine whether another record
When I execute a package body DDL statement SQL Developer warns, Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1
I have a trigger that contains two cursors loops, one nested inside the other like this: FOR outer_rec IN outer_cursor
I have a sample query like below: INSERT INTO my_gtt_1 (fname, lname) (select fname, lname from users)
I have problem with calling for my procedure. Oracle scrams PLS-00306 Error: Wrong number of types of arguments in call to procedure.
加载中,请稍侯......