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 DEBIAN
mail::listdetector::detector::communigatepro
Mail::ListDetector::Detector::CommuniGatePro(3pm) User Contributed Perl Documentation Mail::ListDetector::Detector::CommuniGatePro(3pm)
NAME
Mail::ListDetector::Detector::CommuniGatePro - CommuniGate Pro message detector
SYNOPSIS
use Mail::ListDetector::Detector::CommuniGatePro;
DESCRIPTION
An implementation of a mailing list detector, for CommuniGate Pro mailing lists, See http://www.stalker.com/ for details about CommuniGate
Pro.
CommuniGate Pro mailing list messages are RFC2919 compliant but this module provides more information.
METHODS
new()
Inherited from Mail::ListDetector::Detector::Base.
match()
Accepts a Mail::Internet object and returns either a Mail::ListDetector::List object if it is a post to a CommuniGate Pro mailing list, or
"undef".
Since CommuniGate Pro specifies a (mostly) unique ID for a mailing list in the format of RFC2919, Mail::ListDetector::Detector::RFC2919 is
used to attempt to extract this information about the list.
BUGS
No known bugs.
AUTHOR
Matthew Walker - matthew@walker.wattle.id.au, Michael Stevens - michael@etla.org, Peter Oliver - p.d.oliver@mavit.freeserve.co.uk.
Tatsuhiko Miyagawa <miyagawa@bulknews.net>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-06-30 Mail::ListDetector::Detector::CommuniGatePro(3pm)