06-05-2008
Hi Jim,
Thanks for you answer.. but i received the same error again even if i put in a PL/SQL block?
My Pro*C version:
Pro*C/C++: Release 9.2.0.6.0 - Production on Thu Jun 5 15:52:25 2008
Error Message:
select count(cln_no) over (partition by cln_no ) from temp
...........................1
PLS-S-00103, Encountered the symbol "(" when expecting one of the following:
, from into bulk
I used the following compiler options:
proc parse=full mode=oracle userid=****/**** sample.pc sqlcheck=semantics
I used the query in the pl/sql block only.
Can you please tell me where i would have went wrong?
Last edited by quintet; 06-05-2008 at 12:01 PM..
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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 NETBSD
disktab
DISKTAB(5) BSD File Formats Manual DISKTAB(5)
NAME
disktab -- disk description file
SYNOPSIS
#include <disktab.h>
DESCRIPTION
disktab is a simple database which describes disk geometries and disk partition characteristics. It is used to initialize the disk label on
the disk. The format is patterned after the termcap(5) terminal data base. Entries in disktab consist of a number of `:' separated fields.
The first entry for each disk gives the names which are known for the disk, separated by `|' characters. The last name given should be a
long name fully identifying the disk.
The following list indicates the normal values stored for each disk entry.
Name Type Description
ty str Type of disk (e.g. removable, winchester)
dt str Type of controller (e.g. SMD, ESDI, floppy)
ns num Number of sectors per track
nt num Number of tracks per cylinder
nc num Total number of cylinders on the disk
sc num Number of sectors per cylinder, ns*nt default
su num Number of sectors per unit, sc*nc default
se num Sector size in bytes, DEV_BSIZE default
sf bool Controller supports bad144-style bad sector forwarding
rm num Rotation speed, rpm, 3600 default
sk num Sector skew per track, default 0
cs num Sector skew per cylinder, default 0
hs num Headswitch time, usec, default 0
ts num One-cylinder seek time, usec, default 0
il num Sector interleave (n:1), 1 default
d[0-4] num Drive-type-dependent parameters
bs num Boot block size, default BBSIZE
sb num Superblock size, default SBSIZE
ba num Block size for partition `a' (bytes)
bd num Block size for partition `d' (bytes)
be num Block size for partition `e' (bytes)
bf num Block size for partition `f' (bytes)
bg num Block size for partition `g' (bytes)
bh num Block size for partition `h' (bytes)
fa num Fragment size for partition `a' (bytes)
fd num Fragment size for partition `d' (bytes)
fe num Fragment size for partition `e' (bytes)
ff num Fragment size for partition `f' (bytes)
fg num Fragment size for partition `g' (bytes)
fh num Fragment size for partition `h' (bytes)
oa num Offset of partition `a' in sectors
ob num Offset of partition `b' in sectors
oc num Offset of partition `c' in sectors
od num Offset of partition `d' in sectors
oe num Offset of partition `e' in sectors
of num Offset of partition `f' in sectors
og num Offset of partition `g' in sectors
oh num Offset of partition `h' in sectors
pa num Size of partition `a' in sectors
pb num Size of partition `b' in sectors
pc num Size of partition `c' in sectors
pd num Size of partition `d' in sectors
pe num Size of partition `e' in sectors
pf num Size of partition `f' in sectors
pg num Size of partition `g' in sectors
ph num Size of partition `h' in sectors
ta str Partition type of partition `a' (4.2BSD filesystem, swap, etc)
tb str Partition type of partition `b'
tc str Partition type of partition `c'
td str Partition type of partition `d'
te str Partition type of partition `e'
tf str Partition type of partition `f'
tg str Partition type of partition `g'
th str Partition type of partition `h'
FILES
/etc/disktab
SEE ALSO
getdiskbyname(3), disklabel(5), disklabel(8), newfs(8)
HISTORY
The disktab description file appeared in 4.2BSD.
BSD
June 5, 1993 BSD