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.
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)
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)
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)
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)
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)
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)
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)
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
partitio
PARTITION(8) System Manager's Manual PARTITION(8)NAME
partition - make a partition table
SYNOPSIS
partition [-mf] device [type:]size[+*] ...
DESCRIPTION
Partition makes a partition table on device using the types and sizes given. It may be used in combination with repartition(8) for auto-
matic installation of Minix.
You may give up to four type:size[+*] specifications for the partitions. You may also specify holes before, between, and after the parti-
tions. A hole differs from a partition specification by not having a type.
The first hole is by default 1 sector to make space for the primary bootstrap and the partition table. The other holes are 0.
The type field is the type of the partitition in hexadecimal. The size field is the partition's size in sectors. The + or * may option-
ally be added to indicate that the partition must be expanded to contain any leftover space on the device or to mark the partition active.
Partitions are padded out to cylinder boundaries, except for the first one, it starts on track 1. Some operating systems care about this.
Minix and MS-DOS do not.
OPTIONS -m Minix only, no need to pad partitions. This is the default for subpartition tables.
-f Force making a partition table even if the device is too small.
EXAMPLE
partition /dev/hd0 01:16384 81:40000 81:2880* 06:20000+
Partitions disk 0 into an 8 Mb DOS partition, 20 Mb Minix /usr, 1.44 Mb Minix / (active), and a DOS partition of at least 10 Mb at the end
of the disk. (06:0+ would have been ok too, it's just a sanity check.)
SEE ALSO hd(4), part(8), repartition(8).
AUTHOR
Kees J. Bot (kjb@cs.vu.nl)
PARTITION(8)