Search results for query: *

I have the select stmt in a variable. I need to have it a variable for some conditional from and whre clauses. I need to come up with temp tables and get the output into temp tables for further joins.

I have stmtvar to have the selct statement in my procedure. stmtvar= 'select * from A,B,C ....lots of logoc in there.....' I wanted to execute and insert the data to a temp table called DATA. and again I need two more temp tables from Above temp table DATA. One is to contain A specific data...

I created a derived table calling a pipelined funtion and trying to pass multi value prompt value as parameter to the funtion. But it is not letting me to do it... throwing an error 'Right Paranthesis Missing'. param is a single value prompt. param1 and param2 are set to allow multi vlaues. If...

I didn't get any thing. If user selects a,b,c. when I pass the it as a parameter it will be some thing like this 'a,b,c'. but in sql it has to be ('a','b','c'). I am not sure how to convert 'a,b,c' to 'a','b','c'.

I have a function with a parameter. I need to pass multiple values to single parameter. example parameter value 'A,B,C' in sql it has to be IN ('A','B','C'). Can any one please provide me the solution FUNCTION MTO_ENG104_PIPELINED (str VARCHAR2) RETURN WBS_TAB PIPELINED IS...

Thank you for your response

Instead of having too many cursors, can't we have variables for select, from clauses. and use those variables in main sql. SELECTSTMT VARCHAR2 (2500) := 'P.PART AS PART,' + 'P.VDESC AS VDESC,' + 'P.UM AS UM; FROMCLAUSE VARCHAR2(2500) := TABLE_NM +'AS P'; PRAGMA AUTONOMOUS_TRANSACTION...

I need to place the select statement into a variable. I have some thing like this SELECTSTMT VARCHAR2 (2500) := 'TO_CHAR (Date_Col, 'MM/DD/RRRR'),' +'col_nm1,' +'" DECODE ('col_nm2,''0', 'Active Part',' DECODE (col_nm2,''1', 'Obsolete...

I found a solution for this. I figured out how to create variables in functions and wanted to use them in cursor.But not sure how to use them in cursors. When I exucte pakage throwing an error ([Warning] ORA-24344: success with compilation error 30/18 PL/SQL: ORA-00942: table or view does not...

Yes, it works. is there any way we can run one cursor based on val parameter value? in this case...it will execute all the cursors and get the data and then filters the data right... my lead to performance issues. Am I correct?

I am very new to both business objects and oracle 11g. All the seniors in the team recommended using pipelined function. We already have pipelined functions. Based on existing functions I came up with the above package and function in it. But as per the report logic as I mentioned I need to...

we have 3 tables p_A,p_B,p_C. when user selects product category type A, then we need to get the data from p_A. if the user selects product category type B, then we need to get the data from p_B. user selects product category type C, then we need to get the data from p_C. Val is the parameter...

I have a package with pipelined function in it. using the below stmt to execute the function. select * FROM table(Test_PKG.Test_PIPELINED ('A','--N/A--','1/1/2010','1/1/2011')); Throwing an error: invalid month error. Can any one please let me know where I am doing wrong. CREATE TYPE WBS_ROW...

I have a package with a pipelined function with 3 parameters. Based on Val parameter I need to get the table name. for example if user select A then the table name that I should use is p_A, if user selects R the table name should be p_R. I am thinking of creating a variable and set the...

Is it possible to hide prompt in webi Reports. I need to create 5 reports from 1 universe. universe is using a pacakge with a stored procedure. I wanted to pass report name to the stored procedure to differentiate between the report's sql and based on report name parameter I wanted to take...

Thank you Peter.. I really appreciate your help

Thank Peter

I need to generate Dynamic SQL for cascading Parameters. Here is the scenario. Parameters: Department ---- Values: A-Department, B-Department Category ---- A1, A2, A3, B1, B2 Product --- A1P1, A1P2, A2P1, B1P1, B2P1, B2P2, B2P3 If user selects A-Department the SQL Should use Dept_A table and...

I need to generate Dynamic SQL Based on Parameter selection. Here is the scenario. Parameters: Department ---- Values: A-Department, B-Department, C-Department If user selects A-Department the SQL Should use Dept_A, Product_A and Sales_A Tables If user selects B-Department the SQL Should use...

Getting error message: conversion failed when converting _A to int