Mufasa,
I am working on a data mart as part of a commercial package. Each customer will have its own data mart and production database, which will initially be cloned from a base version. We don't want to hard-code the logon/password/schema information into every version of the data mart. As...
All,
When I execute this from within a stored proc, I receive an "Invalid SQL" error:
EXECUTE IMMEDIATE ('connect DMart_Phase2/dmartphase2@MXDOWL02');
Any help appreciated.
TIA,
Mike
If I try to execute the following:
GRANT SELECT ON DMART_TEST.ERACCOUNTDIM TO FINANCE_ML_QA;
I receive a "Table or View does not exist" message.
If I add the database:
GRANT SELECT ON MHBENG02.DMART_TEST.ERACCOUNTDIM TO FINANCE_ML_QA;
I receive a "Missing keyword" error message.
Any...
All,
I need to link in tables that are in a different schema. How can I do this in a stored proc (as opposed to SQL*Plus).
I'm coming back to PL/SQL after working with T-SQL and I'm a little rusty... In addition, I couldn't find how to do this in any of the 7 PL/SQL books available to me...
Another option is to create a table - CurrentMonth - that is truncated and refreshed as needed with the current month's data and to use this in your report.
Another option is to have a single table and use Between to filter on the month-begin and month-end dates (which can be passed as...
You are going to have to use dynamic SQL, either in your front-end application or in Oracle. I would use a stored procedure to calculate the table name and use dynamic SQL within the stored procedure to create and submit the SQL statement.
Mike
Thanks for the information. The report requires 3 different displays of data and all 3 require a detail row. If you or anyone else knows how to do this within a single report, I'd love to hear about it.
Thanks again!
Mike
I am working on a report that will consist of 3 sub-reports. The data for all 3 sub-reports comes from a single stored procedure. I am opening the stored procedure in the master report. Is there some way to share this datasource among the 3 sub-reports?
TIA,
Mike
Thanks for the response.
I tried spoofing CR by changing the datasource to a SQL statement: "EXEC dbo.pr_PendingJournal @p_StartDate, @p_EndDate, "PENDED"". When I create the 3 parameters and try to save it, I receive a "must declare the variable @p_StartDate" error.
However, I can create a...
I have a CR 9 report that calls a SQL Server 2000 stored procedure. The SP requires 3 parameters. One of the parameters tells the SP which transaction type to select. I want this parameter to be hard-coded, that is, I will set it differently in every report that uses this SP. I want the report...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.