Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Analytic functions in Pro*c
Top Forums Programming Analytic functions in Pro*c Post 302201969 by jim mcnamara on Tuesday 3rd of June 2008 02:49:53 PM
Old 06-03-2008
The parser for SQLPLUS is different than the one for Pro*C.
You will have to use embedded PL/SQL define bound variables, then use those to retrieve your PL/SQL cursor eg:
Code:
EXEC SQL BEGIN DECLARE SECTION;
      long myarray[500]={0};
EXEC SQL END DECLARE SECTION;

EXEC SQL EXECUTE
DECLARE 
     other variables go here
BEGIN
select count(emp_no) over (partition by emp_no ) from temp 
     into :my_array;
END;
/

END-EXEC;

You can also declare a SQL_CURSOR, ALLOCATE the cursor, have PL/SQL declare the cursor in embedded pl/sql, then OPEN the cursor in C, close the cursor in C, finally FREE the cursor. Check your docset for examples.
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

domain logon problem - FreeBSD PDC w/ win2k pro and winxp pro

this is the seventh problem i'm having with samba. for some reason, i cannot logon to the domain. i've created user accounts... and i was able to establish a connection between the samba server (my PDC) and my workstations by logging in as "root." however now when i try to logon it gives... (5 Replies)
Discussion started by: xyyz
5 Replies

2. Shell Programming and Scripting

Regarding functions

Hi, I have a function or script like this. show() { echo "Hi" } | tee -a log show This creates a logfile and prints Hi in it. Now when I try to do the same for sql like this: show() { sqlplus -s scott/tiger<<! select * from details; ! } | tee -a log show Then it gives me a... (2 Replies)
Discussion started by: sendhilmani
2 Replies

3. Shell Programming and Scripting

Use of functions

Hi my shell is tcsh can I have functions in my shell scripting? Is the below shell script correct. Can I have two functions and call one of them as required. ---------- echo "functions" f1 f1 () { echo "hello" } f2 () (1 Reply)
Discussion started by: amitrajvarma
1 Replies

4. UNIX for Dummies Questions & Answers

Help with functions

Hi, I am exploring with defining functions in my BASH shell scripts. However, I am bit confused about how to pass parameters to my functions. I was under the impression that you must do something like the following: Define a function called "sample_function": function sample_function {... (3 Replies)
Discussion started by: msb65
3 Replies

5. Shell Programming and Scripting

i think i need functions ?

Hi, im making a little script but need some help Code i have so far is read -p 'Bot Nickname:' ecnick read -p 'Bot Username:' ecusername read -p 'Bot Realname:' ecrealname read -p 'Your Email:' ecemail echo '' echo Your bots nickname is set to $ecnick echo Your bots username is set to... (2 Replies)
Discussion started by: Gemster
2 Replies

6. Programming

Functions

Hi All, Can any one help me. I am calling in a function2 with string as parameter from function1, the function1 gives 3 values. how i get the 3 values from funciton2 to function1. i have to give a return or something. thanks in advance. (2 Replies)
Discussion started by: uday.sena.m
2 Replies

7. Shell Programming and Scripting

How to execute functions or initiate functions as command line parameters for below requirement?

I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line if then... (8 Replies)
Discussion started by: saku
8 Replies

8. UNIX for Beginners Questions & Answers

Deleting unused kdb+ analytic files in RedHat

Hello guys :) I am new to using Unix and was hoping somebody could help me. Essentially, I am trying to clean out my database. For example, I have a directory filled with 100s of analytics and I want to know if they are used by any other analytics or if they are used by the front end user... (17 Replies)
Discussion started by: Michael37
17 Replies

LEARN ABOUT MINIX

repartit

REPARTITION(8)						      System Manager's Manual						    REPARTITION(8)

NAME

       repartition - load a partition table

SYNOPSIS

       repartition device [partition-file]

DESCRIPTION

       Repartition  uploads  a new partition table for the partitions of device.  The table is obtained from the first sector of partition-file if
       given, device otherwise.  Device may refer to the whole drive or a primary partition, depending on whether you want to upload  a  partition
       or a subpartition table.  The partitions will be truncated to fit within the enclosing device like the disk driver does, unless the numbers
       are coming from partition-file.

EXAMPLES

       repartition /dev/hd0
       repartition /dev/hd4 /etc/hd4.table

       Reload the partition table of drive 0 setting /dev/hd[1-4], and the subpartition table of /dev/hd4 setting /dev/hd4[a-d] using a file.  The
       latter may be useful if you need more than the 4 subpartitions a single Minix partition gives you.

DIAGNOSTICS

       The new table is printed on standard output.

FILES

       /dev/hd[0-9]

SEE ALSO

       hd(4), part(8).

BUGS

       The disk must be in use for the changes to stick.  The partition table of an idle disk will be reloaded on the first open.

AUTHOR

       Kees J. Bot (kjb@cs.vu.nl)

																    REPARTITION(8)
All times are GMT -4. The time now is 04:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy