Search results for query: *

Our 3rd party software vendor has altered tables. We have written our own reports, etc. to access their data. We will have to rewrite much of our views, functions, and procedures. Rather than going through every object, I would like to identify those that require changing.

Using system views, can the table be identified within user written views and functions? Example: I have functions that access a table. Can I query the database to identify all the functions the table is in? Thank you.

I need to execute a view statement to do the following: Table A Loan_Number Loan Officer Table B Loan_Number Borrower_Name Table A Values Loan Number: 123 Loan Officer: FRANK Table B Values Loan Number: 123 Borrower Name: SMITH Loan Number: 123 Borrower Name: JONES Query Output Needed...

I want to produce a GroupWise address book (.NAB) file. Using export, I can produce the data in the format needed. The problem I have is I need to generate ONE header record before the detail records. The header is used when the address book is populated into GroupWise.(The header contains...

I have a one-to-many relationship between tableA and tableB. I need to write a sql statement to select data from the parent tableA and, on a single field, combine data from the child tableB. Example: TableA has property information TableB has contact information for the property My...

Is it possible to execute a stored procedure within a view? Thank you.

I'm new to the use of temporary tables. I'm trying to create a temporary table using the following procedure: create or replace procedure P_X1 execute immediate "CREATE GLOBAL TEMPORARY TABLE X_TABLE ( x_year NUMBER(4), x_MONTH VARCHAR2(9)) ON COMMIT PERSERVE ROWS"; END P_X1; I'm...

Thanks for the feedback.

I have 5 records, each with a different expiration date: 20010601 20020520 20030316 20041230 20051007 I have to find the one record where the comparenumber is the highest value without exceeding the comparenumber Example: Comparenumber (from another table) = 2050206 I need to select only...

I'm using DreamWeaver MX to write a date field to an Oracle 9i database. The date is not the system date. The only way I can enter the date is in the format: dd-mmm-yy. How can I change the format in DreamWeaver to enter the date as mm/dd/yyyy? Thank you.

Ok. Thank you.

Hello - GroupWise Version: 6.5 I've set up proxy access to send emails in my name. Is it possible for me to receive notification of a failed email due to a bad address - without the proxy creating a rule? The failure notice is received by the proxy only. Thank you

Selected data was not able to be accessed from the Oracle 9i database. No errors were reported. A compiled AcuCobol program (last compiled in 9/2003) and Crystal 8.5 did not find the data. A dump (BUT NO RELOAD) of the data was executed. Following the dump, the missing data was found by the...

Thank you for the feedback. The dbms_obfuscation_toolkit package works fine....is there a way, in memory, to pass the decrypted password directly to a connect command? Thanks.

In Oracle 9i is there way to encrypt the command line password? Thank you.

The Oracle login name and password are in plain text. Can the password be encrypted? Thank you.

Ok. Thank you for the feedback.

I can append a report to a command line with CRW.EXE. It does open. Are there other line commands to have the report execute, pass parameters, and finally to exit Crystal after the report ends? Version: Crystal Reports 8.5 Thank you

I can create a custom connection string for Oracle 9i and connect to Oracle using the drivers on the local machine. When I select the option to use the drivers on the testing server, the connection hangs. Thank you.

I'm producing a Crystal report (8.5) (on a Win2000 platform) using an Oracle 9i view. The view selects data from 13 tables and contains 40 fields. If I select a small number of fields for the Crystal report, the report executes fine. If I select all or most of the fields, Crystal hangs. (A...