[plsql] Forum Topics

string query = "DECLARE l_cursor SYS_REFCURSOR;ServiceName la_service_provider_detail.service_name%TYPE;Surname people.surname%TYPE;Forename people.forename%Type;"+ "Action Varchar(50);Rate ey_pupil_premium_log.rate%Type;"+ "Funding_Code single_funding_formulas.funding_code%Type;"+ "BEGIN EYPupilPremiumPackage.GetEyPupilPremiumLog(pLogId=> 6613, pPreview => 'T',EyPupilPremiumLog=> l_cursor);"+ "LOOP"+ "FETCH :l_cursor "+ "INTO ServiceName, Surname, Forename,Action,Rate,Funding_Code;"+ /*IF l_cursor%NOTFOUND"+ Then DBMS_OUTPUT.PUT_lINE('NO DATA FOUND'); EXIT WHEN l_cursor%NOTFOUND; END IF; "END LOOP;"+ "DBMS_OUTPUT.PUT_LINE(ServiceName || ' | ' || Surname || …

Hi , here is my procedure where i want to return the open cursor to client using EyPupilPremiumLog parameter and then have to loop through for looging purpose which i cudnt able to do.. tried fetch /for etc but missing somewhere the nuanses .. Advise would be helpful. PROCEDURE GetEyPupilPremiumLog(pLogId …

Hi I have a procuder which return a recordset using cursor in output what am trying to do is i use cursor to get the data and same have to return it to output cursor .I can do like below PROCEDURE test(value_one IN someTabel.somecolumn%TYPE, valu_two IN someTabel.somecolumn%TYPE, Outputcursor OUT SYS_REFCURSOR) …

Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | …

Hello All, I want to write the plsql stored procedure to insert multiple rows in a table. Table t1, table t2. Table t1 column names(c1,c2,c3,c4,c5) table t2 column name (c2,c3,c4) column names c2, c3, c4 are same in both tables. BEGIN INSERT into t1(c1,c2,c3,c4,c5) select "a" as c1, c2, c3, …

Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function …

Hi Folks, I am having problem with my web design. I am making a query that involves two table but it doesnt do anything when i click submit. do i make mistake in the query ? my code is like this, <?php if ($_POST['action'] == 'show'){ $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, …

Hi folks, I have a question regarding auto-generate row oracle using sequence. So the deal is, I need to make a list of inventory based on its quantity. So I have a table with 3 columns, 1. Component ID 2. Quantity 3. Sub_component. So when user input a component id …

Hi, I have created a parameter table, added 1 column to it and populated that column with 1 value as shown here: CREATE TABLE tbl_param( maxcount NUMBER); INSERT INTO tbl_param VALUES (5); My problem is I want to create a loop from 1 to 5, but instead of just using …

Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …

Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from …

have got this update script updating certain columns [CODE]update oppar set oppar_run_mode = 0, oppar_run_time = 0, oppar_interval_ind = 'N' , oppar_destination = '', oppar_run_date ='', oppar_run_interval='' where ( oppar_job_name, oppar_job_rec ) in ( ('CSCLM' , 'XYZ') , ('ARCLEVEXT' , 'LMN'));[/CODE] But there are cases where there is no record …

please convert this below query to plsql format select (select count(*) from cadastredefunct t where t.areacode= 'PTH01' AND T.SECTIONNUMBER = 'D' and t.defunctnumber <> 'ONGD') as total, (select count(*) from cadastredefunct t where t.areacode = 'PTH01' AND T.SECTIONNUMBER = 'D' and t.status = 'COMP' and t.defunctnumber <> 'ONGD') as completed, …